Understanding Level Break Footers
Level break footer sections present information that appears after the records that are associated with the level break field. Fields within the level break footer are used for displaying aggregates.
An aggregate is an object that holds the results of a calculation using the values in other fields. For example, the calculation could be a sum of values, an average of values, or a count of how many records exist. After adding a level break footer and assigning the totaling conditions to the aggregate object within the level break footer, you might need to change the totaling conditions to meet other reporting requirements. If you are using the level break footer to accumulate totals, the values in those fields are calculated dynamically at runtime.
Due to their free-form layout, group sections are typically used for level break footers. Use the columnar section level break footer option when you want the aggregates but not the detail section to print in the report. The aggregate fields appear in a row beneath the column headings. You can define more that one level break footer in a report template. For example, you can define the search type and business unit fields as level break fields to provide more detailed aggregates.
When defining aggregates, determine the appropriate operator as defined in this table:
Operator |
Description |
---|---|
Average of |
Reports the average of all the amounts in the column. |
Count of |
Reports how many entries or records are in the column. |
Maximum of |
Reports the maximum amount for a record in the column. |
Minimum of |
Reports the minimum amount for a record in the column. |
Total of |
Reports the sum of the values in this column. |
The operator that you select determines the available selection of operands. Operands are columns that are included in the report layout.
You can select line types to appear with the aggregates. You can select either or both:
Single overline
Double underline
When creating level break footers, the last option is to define whether you want the aggregates to reprint at the page break. This option reprints the aggregates from the previous page onto the succeeding page. This is important when the level of data continues from one page to the next.
In the RDA workspace, the level break footer appears within the detail section. The name of the level break footer usually begins with On and indicates the level break field on which it was created. In the report tree, the level break footer appears one branch below the section to which it is attached.