New article
Recently updated
Adding a Summary Field to a Report
A 'Summary Field' is simply a Standard Control Label which has a Summary type defined, and therefore can be created in Report Designer for any Ideagen Quality Management Module.
The Summary Region/Scope can be Group, Page or Report, depending on your data.
i.e. you can calculate a Total for a specific section of your report, or the entire report.
To add the Summary Field:
- Add a Footer Band to your chosen Summary Region (Group, Page, Report)
- e.g. Right Click the Detail Band > Insert Band > Report Footer
- Drag a New Label to the Footer
- Select the Label, then Click the [>] icon to view the Label Tasks
- Select the ellipses (...) icon on the Summary Field, this display the Summary Editor
- Here you can define the criteria of the Summary Function:
- Bound Field: The Field Data you wish to perform the function on
- Summary Function (See below)
- Format String: Specify the display format of your result
- Summary Running: Defines the Region of your Field
Summary Functions
| Function | Description |
| Average | Calculates the average of all the values within the specified summary region |
| Count | Counts the number of values within the specified summary region |
| Sum | Calculates the total of all the values within the specified summary region |
| Running Summary | When Groups of Data are repeated, this will display a total of the current group plus any previous groups. |
| Percentage | Calculates the percent ratio of the current data row's value to the total of all the values within the specified summary region |
| Min | Calculates the minimum of all the values within the specified summary region |
| Max | Calculates the maximum of all the values within the specified summary region |
| Median |
Finds the middle number within a sequence.
Note: If the total number of elements is even, this function returns the arithmetical mean of the two middle numbers. |
| Variance | Calculates the amount of variance for all the values within the specified summary region |
| Population Variance | Calculates the population variance of all the values within the specified summary region |
| Standard Deviation | Calculates the standard deviation of all the values within the specified summary region |
| Standard Population Deviation | Calculates the standard population deviation of all the values within the specified summary region |
| Average (Distinct) | Calculates the average of all the distinct values within the specified summary region |
| Summary (Distinct) | Calculates the total of all the distinct values within the specified summary region |
| Variance (Distinct) | Calculates the amount of variance for all the distinct values within the specified summary region |
| Population Variance (Distinct) | Calculates the population variance of all the distinct values within the specified summary region |
| Standard Deviation (Distinct) | Calculates the amount of variance for all the distinct values within the specified summary region |
| Standard Population Deviation (Distinct) | Calculates the standard population deviation of all the distinct values within the specified summary region |
| Record Number | Returns the current record number in the data source within the specified summary region. This means for instance, if the summary is calculated for a group, then the record number is calculated only within that group, and is reset every time a new group is started. |
| Custom | Unused |