About row attributes

Code and description

The row code is an unique value specified by the system when you add a new row to the row set. This code is used to identify the row within the row set, and the references to the rows in the formulas also include the rows codes. The code assigned to the row can be changed later, but we do not recommend that you change the existing row codes, because they can be used in the formula references to this row. The rows in the row sets are sorted by the row code in ascending order, and this is the order they appear in the generated report. We also do not recommended that you use the successive values as the codes of new rows added to the row set to simplify the procedure of adding the rows to be inserted into the report between the existing ones. The row description is a descriptive definition of the row contents. The data from the Description field is not printed in the analytical report. To include the row description in the report, you should create a caption for this row.

Type

By defining the Type attribute in the row set, you specify what data will be displayed in a particular report row, and how the data in the row will be processed. You can select one of the following row types:

Type	Description
General ledger	A row type that you select when the data to be displayed in the row does not include some calculated values like yearly or quarterly totals and can be used as a source in the summarised data calculations. This row type can be selected when no formulas are used to calculate the values in the row.
Caption	A row type that you select to set the caption for a row or a group of rows. The row caption can be printed on a separate line in the report or merged with the data in the next row of the row set and displayed in the specified column on the next report line. To print the caption on a separate line, you should select Caption in the Type field, then specify the Style attribute to define the caption printing style, and specify the default settings for the other attributes in the row. To display the caption on the same line, specify the Column group attribute for the row, which defines a caption, and select the Merge next option for the Printing control attribute.
Line	A row type that you select to insert a row separating line in the report. The separating lines are used to improve the report readability and visually segregate the groups of data displayed in the report lines. You can specify the line style for the separating lines by setting the Line style attribute for the row.
Total	A row type that you select when the data displayed in the row includes some calculated values like yearly or quarterly totals and should be excluded from the volume of data that can be selected as a source for summarised values calculation. This row type is commonly used when the row includes a formula which calculates the sums or total values.
Header	A row type that you select to print the specific header in this row in the report. You should specify the header in the Headers section of the Column sets (CS206020) window. To display the header in the report, specify the Column group attribute for the row, which defines a header. This attribute specifies the reference to the appropriate header defined for the column set included in this report.

Value

By specifying the Value attribute, you can define a certain value to be displayed in the report line. The values in the rows can be predefined parameters or computed values calculated using formulas. Values are frequently used to insert the sums and totals into the report lines.

The formulas used to calculate the data in the report lines usually include the references to other rows or particular cells in the report. The expressions used to insert the data in the report rows can also use the parametric queries to select the necessary data from the data source.

Note: When you use the Values attribute to display the total values in the row, it is necessary to confirm that the appropriate Row type attribute is selected for this row to exclude it from the data that can be selected as a source for summarised values calculation.

Format

You use the Format attribute to specify the format functions for the row cells. For the rules of the row cell formatting, see Cell formatting

Data source

You use the Data source attribute to define the filtering criteria for the data to be displayed in a specific row of your report. To set up filtering criteria, you should specify appropriate parameters in the Data source editor dialog box. You can specify criteria on different levels (row, column, unit, or entire report). The filtering rules defined for the unit have the highest priority. The rules defined on the row, column, and report levels have the next highest priorities (in that order). For example, if you want to define filtering criteria for a column and these criteria differ from the criteria that has already been specified for the rows, you need to clear the parameters or specify them as Not set for the row that interacts with the corresponding column so that the data filtering criteria specified for the column will be applied.

By specifying the data filtering parameters on the row level, you define the data structure in the report. For example, if a group of lines in the report must display the calculated values for the specific period, you should set the start date and the end date of the period for each row included in this group of report lines. If some lines in the report must display the data related to a specific account, and the columns must display the values calculated for certain periods, you should specify the account on the rows level, and set the start date and the end date of each period on the columns level.

Style

You can use the Style attribute to define the printing style, such as the font, background colour, or text alignment, for the data in a specific report row. This attribute can be used when some report row must be visually emphasised and have formatting that differs from that of the other rows in the report. For example, you can set special formatting attributes for the rows that include the total values for some periods.

Printing control

You use the Printing control attribute to specify how the rows will be printed in the report. The following printing control options are available for the rows:

Parameter	Description
Line break	The option you select to insert a line break after each row. In this case, each row will be printed on a separate line.
Merge next	The option you select to merge the row data with the data in the next row. When two rows are merged, the values from the merged row are inserted in the free cells of the next row. To merge the rows, you should define in which columns of the next row the data will be inserted, by setting the Column group attributes for the merged rows. You can merge the rows, for example, when some report line must include data from various rows selected from the database by using different selection criteria.
Start box and End box	The option you select to visually group a certain number of sequential rows by adding a frame box to these rows in the printed report. Use the Start box option for the first row in the group of rows to be included in the frame, and use the End box option for the last row in this group.

Page formatting and row printing control attributes

Multiple row attributes are used to define the page formatting and to control printing. These attributes include the options that allow you to set the row printing options and block the empty lines printing.

Attribute	Description
Page break	This attribute allows you to insert a page break in the printed report after the current row.
Height	This attribute allows you to set the row height in the printed report (in pixels).
Indent	This attribute allows you to set the row indent in the printed report (in pixels).
Line style	This attribute is used to set the line style for the row having the Underline type.
Suppress empty	This attribute is used when the empty lines must not be printed in the report.
Hide zero	This attribute is used to print blank spaces instead of zero values in the row.
Linked row	This attribute enables inheriting the printing control properties of a row in the row set from the printing control properties of another row. The printing control properties of a row are defined by the values of Printing control, Suppress empty, and Hide zero attributes. Linked rows are used when the two rows should be printed or not printed in the report simultaneously, and the printing control properties of the first row are used to set the printing control properties for the second row. To define the row whose printing control properties should be used to set the same properties for the current row, you should enter the code of this row in Linked row for the current row attributes set.

Column group

The Column group attribute is used to define the group of columns where the values from the current row will be printed. Every column group selected for the current row can include one or several columns. When a column group attribute is set for the current row, the same value should be assigned to the Printing group attribute for the columns that will be included in this analytical report and where the values from the current row will be inserted. For example, if the values from the row having the R01 code should be displayed in the columns A and B, the Column group attribute should have the same value as the Printing group attribute defined for the columns A and B.

Unit group

You use the Unit group attribute to include the current row in the unit group. Unit groups are used to generate summarised or aggregated reports, to define the groups of rows to be displayed in some specific reports. Unit groups include the column sets and row sets into the hierarchically organised units that can be used to summarise the values in the report formed from the various column sets and row sets.