Overview
Report definitions may include a user-defined totalling hierarchy. Each calculated line may be assigned to one of 4 totalling levels (1 to 4). The default totalling level is 1.
Where a calculated line is the sum of two or more level 1 lines, you should assign that line to totalling level 2 if you wish to reflect this in the report.
When the totalling levels is set for a line, the Report Definition Editor displays that line using the same shading level that will be used in a report. Darker shading represents lower totalling levels.
Example
Here, line 3 is set to totalling level 1 to reflect the fact that it is the sum of two base level lines. Similarly, line 7 is assigned to totalling level 2 to reflect the fact that it is the sum of two lines with total level 1.
Outline Bars
Outline bars may be used to show or hide the different levels of the report line hierarchy when viewing reports based upon report definitions. However, outline bars are only available if the report definition has a proper hierarchy in terms of totalling levels.
For example, the following sequence of totalling levels does satisfy proper hierarchy rules:
Level 1
Level 1
Level 2
Level 1
Level 1
Level 1
Level 2
Level 3
However, the following sequence of totalling levels does not satisfy proper hierarchy rules, as a level 3 line does not follow a level 2 line.:
Level 1
Level 1
Level 3
Level 1
Level 1
Level 1
Level 2
Level 3
It is sometimes necessary to insert redundant lines showing the required totalling levels, even if they are not required in the final report. Such redundant lines may be hidden using the advanced option 'Hidden line'
Comments
0 comments
Please sign in to leave a comment.