> For the complete documentation index, see [llms.txt](https://knowledge.out-smart.com/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://knowledge.out-smart.com/backoffice/backoffice/reports/choose-and-arrange-report-columns.md).

# Choose and arrange report columns

Add, remove, reorder, and sort the columns shown in a report.

## Choose and arrange report columns

### Introduction

Columns control the information in each report row and its display order.

### Detailed explanation

Available columns depend on the selected entity. Financial entities, such as hours, work periods, and invoice lines, include cost and sales values. These include **cost price**, **sale price**, hour cost, and revenue totals.

Select several columns, reorder them by dragging, and set the sort column and direction.

### Step-by-step guide

{% stepper %}
{% step %}

#### Open the report

Create or edit a report, then open the columns section.
{% endstep %}

{% step %}

#### Select columns

Search for and select the columns you need.
{% endstep %}

{% step %}

#### Reorder columns

Drag columns into the required export order.
{% endstep %}

{% step %}

#### Set sorting

Choose the sort column and direction: ascending or descending.
{% endstep %}

{% step %}

#### Preview

Preview the report to check the layout before saving.
{% endstep %}
{% endstepper %}

### FAQ

<details>

<summary>I want cost price per line and total hour cost in the report.</summary>

Choose an entity with cost data, such as hours, work periods, or invoice lines. Add the cost and sales columns like any other column.

</details>

<details>

<summary>Some columns I expect aren't in the list.</summary>

Available columns depend on the selected entity. Add a secondary entity, or change the primary entity, to access related data.

</details>

### References

* [Create a report](/backoffice/backoffice/reports/create-a-report.md)
* [Configure report criteria](/backoffice/backoffice/reports/configure-report-criteria.md)


---

# Agent Instructions
This documentation is published with GitBook. GitBook is the documentation platform designed so that both humans and AI agents can read, navigate, and reason over technical content effectively. Learn more at gitbook.com.

## Querying This Documentation
If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter, and the optional `goal` query parameter:

```
GET https://knowledge.out-smart.com/backoffice/backoffice/reports/choose-and-arrange-report-columns.md?ask=<question>&goal=<endgoal>
```

`ask` is the immediate question: it should be specific, self-contained, and written in natural language.
`goal` is optional and describes the broader end goal you are ultimately trying to accomplish on behalf of the user. GitBook uses it to tailor the answer towards what is most useful for that goal.

The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.