Group And Report Level Totals/Summaries

Trouble seeing the images? Right click on images and open in new tab to enlarge or zoom in on the page (Ctrl + mousewheel).

In this article we cover setting up group and report level summaries in the Finished Reports Designer.

Group / Report Level Summaries Example

Example: Group Summary & Report Summary - Grouped on Employee ID

Important Notes

1. If the calculation is being done at the group or report level, the Summary needs to be set accordingly.

2. Calculations at the Group/Report level need to use sumSum() functions.

Steps For Group Level Calculations

1. Add a label to the Group Footer.

2. Click the menu button on the label.

3. Set the Summary option to Group.

4. Edit the Expression. Use the same logic for any other Expression keeping in mind that each field needs to be within a sumSum(), sumCount(), etc.

Steps For Report Level Calculations

1. Add a label to the Report Footer. (Insert Report Footer by right clicking in the body of the report and selecting Insert Band > Reportfooter)

2. Click the menu button on the label.

3. Set the Summary option to Report.

4. Edit the Expression. Use the same logic for any other Expression keeping in mind that each field needs to be within a sumSum(), sumCount(), etc.

Example Output including Detail level calculations, group and report level calculations.