Row sets (CS206010)
To define what data will be displayed in each analytical report and how it will be organised, you need to define the row set and column set; optionally, you can define the unit set. A row set defines the rows to be included in the report and the data to be displayed in each row. For more information on using row sets, see: About row sets.
This window, which is part of the Analytical report manager, displays the row sets defined for the analytical reports. You use the window to view or modify existing row sets, create new row sets, and delete row sets. For each row set, add the rows to be included in the analytical report and define the properties for each row.
## Search line in list window If you are in the list window, the first line in the table is a search line. Each column has a search field which you can click to search for or filter on specific values and narrow down the displayed table rows. You can search and filter in as many columns as you need to, to only display the results you want to view. There are two types of search fields: + White: here you can type a specific search term to display results in this column containing this exact value. If you search on several (partial) words, you can separate them by a space or **%** and get different results: + space: the result contains the words in any order, + **%**: the result contains the words in the specific order, and the **%** functions as a wildcard as well. + Grey: you can click this to open the column filter pop-up window where you can filter the results for this column.The window toolbar
| Button | Description |
|---|---|
| Copy row set | Initiates copying of the selected row set configuration. If you click this button, you type the new row set code in the New row set code dialog box that opens. |
The top part
This part of the window displays basic information about the particular row set. You can define a new row set, or you can look up an existing one by selecting its code or by using the actions in the window toolbar.
| Element | Description |
|---|---|
| Code | The unique code used to identify the row set. You can use up to 10 alphanumeric characters. |
| Type | The data source of the row set. Select one of the following options:
|
| Description | The descriptive name of the row set. |
The table
The table shows the rows included in the row set, along with their properties, which you can modify. You can add a row to the row set or delete a row from the set.
| Button | Description |
|---|---|
| Copy style | Copies the printing style from a row to use it in another row. |
| Paste style | Pastes the printing style copied from another row. |
| Renumber | Initiates the renumbering of rows. You can type numbering step and code length (up to 10) in the Set numbering step dialog box that opens. The system changes the row codes to comply with new settings. |
| Column | Description |
|---|---|
| Code | The unique code used to identify the row. You can use up to 10 alphanumeric characters. |
| Description | The descriptive name of the row. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Type | The type of the row. This property defines how the values in the row are calculated and whether the column will display any data. Select one of the available options:
|
| Value | The value to be displayed in the row. You can create a formula to define the value and use parameters in the formula you define. > [!NOTE] > This field supports the multi-language functionality, where you can translate the entered text to multiple languages. For more information, see: About multi-language support |
| Format | The format used to convert the data selected from the data source to the string value used in the printed report. C# data conversion functions can be used to convert data to string values. |
| Data source | The source of the data to be displayed in the row. Click the lookup button for the particular row to use the Data source editor dialog box to define the data source. |
| Style | The printing style to be used for this data row. The printing style parameters are defined in the Style dialog box, which you invoke by clicking the selector in the Style field. For the description of this lookup, see the Style parameters section of Printing styles. |
| Printing control | The property that identifies the row’s position in the report and the way the row printing will be controlled. |
| Page break | A check box that, if selected, indicates that a page break should be inserted after the row line in the printed report. |
| Height | The row height in the printed report (in pixels). |
| Indent | The indent value used for the row in the printed report (in pixels). |
| Line style | The line style used when the Underline option is selected for the row type in the Type field. |
| Suppress empty | A check box that prevents (if selected) the printing of empty rows. |
| Hide zero | A check box that prevents (if selected) the printing of zero values in the row. |
| Linked row | The code of the row linked to the current one. The linked rows are printed on the same line in the report. |
| Base row | A row code. You specify the row code in the specific row cell if you need to reference to this row in the formula that you enter in the Value field in the Column sets (CS206020) window (by using the @BaseRowCode parameter) when the system should use the value specified in this row to compute another value. For details, see: About parameters. |
| Column group | The column group to include the row. |
| Unit group | The unit group to include the row. |
Related pages
Concepts
- General ledger windows - overview
- About row sets
- Analytical report parameters
- Column sets - overview
- Column attributes
- Printing styles
- Check accounts for financial statement reports