Row sets are subsets of input or report template rows. They can be used to view a predefined combinations of rows in the input or report template. Row sets are sheet-specific. If the input or report template contains several sheets, you need to define row sets separately to all sheets on which you want to use them.

In the Simple Report example template (EX_RT101) there are three row sets. Columns immediately following the ACCCODE column are for row sets (columns G to I).

1.Add as many columns as you need. Row sets must be named on first row of the area ('Items', 'Sum' and 'All'). This name is shown as the row set name in the Row set drop-down list in the input or report template. The same name is used in all languages.

2.The next empty column marks the end of row set columns.

3.Type a character (for example, X) on the rows that you want to include in the row set. Any characters except special characters are allowed. The same row can be included in multiple row sets.

You can also define row sets with formulas, including IF formulas which make it possible to create row sets dynamically on generated templates. On generated templates, row sets are copied to all generated blocks. In 'retrievefromdata' type templates, the formula must be copied to as many rows as you expect to be the maximum data rows retrieved on the template. 

When you define a row set for a sheet, the application adds the Basic row set option to the drop-down list. It includes all rows and is the default row set. You can change the default row set in the user interface task settings. It is also possible to define whether users can change the row set.

Note!

•Row sets cannot be used in 20 000 and 70 000 document series input templates, drill-down and TR templates, custom templates, or external workbooks.

•The 'Hide zero rows' function works in combination with row sets. If 'Hide zero rows' is set for the sheet, all zero rows are hidden even if they are included in the selected row set.

•Header rows of the areas are always shown.

•Rows that are not included in any area (including empty rows) are not affected by row set settings.

•Row sets with formulas based on a generated data column do not work.

•The ACCCODE naming in the template must follow the order of the sheets; ACCCCODE1 in first sheet, ACCCODE2 in second sheet and so on.

•If there are several areas on the sheet, they must include the same number of columns (total of definition columns and data columns). Otherwise row sets do not work for the areas.