Switch to: V9V8V7V6V5

Report Editor - Summary Help

Aggregate functions are functions where the values of multiple rows are grouped together to form a single summary value. The Summary Control is intended for adding aggregate functions into the report. You have two ways to specify the function:

  • Using Property Inspector for the control:
    • Change property type, to specify a needed item from the list of available functions
    • Change property value, to specify the arguments of the selected function
  • Using the dialog:

Report Editor - Summary Help

The Report Engine provides few aggregate functions:

  • Avg – computes the average of field values.
  • Count – counts the number of records.
  • Max – allows to find the maximum value in the field.
  • Min – allows to find the minimum value in the field.;
  • Sum – computes the sum of field values.

Usage

Aggregate functions, in reports, should be used in the footer regions. Using in the others regions (headers or body), is unusual. Valentina Reports supports aggregate or summary controls in Footer and Header regions. Computation of the function performed on values of fields, which are included into the current region.

Summary Control support in Header groups was added with the release of Valentina 8.7.2.

Example

Suppose you have a simple table, that contains two fields:

  • f_number – some number.
  • f_date – a date of adding of the record.

You needs to create a report, that prints a list of all values of the field f_num, with next conditions:

  • Records should be grouped by adding date.
  • Each group should contains information about summary of own values.
  • Each page of report should contains information about the number of records, printed on the page.
  • At the end of the report should be printed an average value of the field.

For this purpose we will create the report:

Report Editor - Summary Example : Report

let's see, what we will get in the output of the report:

The group of recordsReport Editor - Summary Example : Group
End of the pageReport Editor - Summary Example : Group with and of page
End of the reportReport Editor - Summary Example : Group with and of report

Other aggregate functions works similarly.