Aggregates (Summary)

In a report that aggregates, or collects, data within ranges, values from the database are retrieved and formatted based on an aggregate range that you define. You can even use parameters to specify the range over which the data should be collected.

 Example scenario:

If the user wants to know aggregates like, for the region ‘East’ what were the total sales made between dates.

You can filter the report by ‘East’ and then at the sales column by proving options ‘Count’ and ‘Sum’,

you can know the total sales made and what was the total sum generated out of the sales made.

To generate a summary for a report, select a report from the left pane

the corresponding records are displayed. Move the mouse pointer to the ‘Summary’ icon

provided at the toolbar. All the columns displayed at the report are displayed in here.

Select a column/columns against which the summary needs to be generated.

As you select a column it expands and displays options such as ‘Sum’, ‘Average’, ‘Min’, ‘Max’, ‘Count’.

Select the required and click on ‘Apply button, the summary will be displayed for the selected report.

Note: If the column data type is Integer then the options such as ‘Sum’, ‘Average’, ‘Min’, ‘Max’, ‘Count’

are displayed at the ‘Summary’ toolbar else only ‘Count’ option is displayed.