Navigation: Reporting Functions > Modifying Existing Reports >
Summation Functions
|
Navigation: Reporting Functions > Modifying Existing Reports > Summation Functions |
|
Summary fields are fields that provide summary information. A field must first be assigned a DataField to bind to. Next, set the following properties to create the desired behaviour.
| • | SummaryDistinctField: property sets or returns the name of the field used in a distinct summary function. The summary function will process DataField values based on the distinct value of this field. |
Note: This property is used only when the SummaryFunc value is one of Distinct Summary Functions. When using the summary functions with a field, the CanGrow and CanShrink properties are disabled for the field.
| • | SummaryFunc: Sets the type of the summary function used to process the DataField values. You can use this function to create sub totals, grand totals and other summary values. |
Summary Functions:
Mnemonic |
Description |
ddSFSum |
Calculates the total of all values within the specified summary region (group, page report). |
ddSFAvg |
Calculates the average of all values within the specified summary region (group, page or report). |
ddSFCount |
Calculates the count of all values within the specified summary region (group, page or report). |
ddSFMin |
Calculates the minimum of all values within the specified summary region (group, page or report). |
ddSFMax |
Calculates the maximum of all values within the specified summary region (group, page or report). |
ddSFVar |
Calculates the variance of all values within the specified summary region (group, page or report). |
ddSFVarP |
Calculates the population variance of all values within the specified summary region (group, page or report). |
ddSFStdDev |
Calculates the standard deviation of all values within the specified summary region (group, page or report). |
ddSFStdDevP |
Calculates the population standard deviation of all values within the specified summary region (group, page or report). |
ddSFDSum |
Calculates the total based on the distinct values of another field within the specified summary region (group, page or report). |
ddSFDAvg |
Calculates the average based on the distinct values of another field within the specified summary region (group, page or report). |
ddSFDCount |
Calculates the distinct count based on the distinct values of another field within the specified summary region (group, page or report). |
ddSFDVar |
Calculates the variance based on the distinct values of another field within the specified summary region (group, page or report). |
ddSFDVarP |
Calculates the population distinct variance based on the distinct values of another field within the specified summary region (group, page or report). |
ddSFDStdDev |
Calculates the standard deviation based on the distinct values of another field within the specified summary region (group, page or report). |
dSFDStdDevP |
Calculates the population standard deviation based on the distinct values of another field within the specified summary region (group, page or report). |
| • | SummaryGroup: property sets or returns the name of the group header section that will reset the summarized field value. For example, setting a sum of price for an order group header, will reset the sum to zero for each order group. This property is valid when the SummaryType is set to 3-SubTotal. |
Note: When using the summary functions with a field, the CanGrow and CanShrink properties are disabled for the field.
| • | SummaryRunning: determines whether the summarization will be accumulated or reset for each level (detail, group or page). Setting this property ddSRGroup or ddSRAll will make WireCAD print a running summary of the field at the group or report level. |
Note: When using the summary functions with a field, the CanGrow and CanShrink properties are disabled for the field.
| • | SummaryType determines the type of summarization on the field if any. WireCAD can summarize the field as: |
| • | Sub total (group level; reset for each group). |
| • | Grand total (report level; do not reset until all records are processed). |
| • | Page total (page level; reset for each page). |
| • | Or a page count, which is the total number of pages printed. |
Summary Types:
Mnemonic |
Description |
ddSMNone |
No summarization. |
ddSMGrandTotal |
Specifies a report level summary, evaluates the summary function for all records in the report. |
ddSMPageTotal |
Specifies a page level summary, evaluates the summary function for all records on each page. |
ddSMSubTotal |
Specifies a group level summary, evaluates the summary function for all records in each group level. |
ddSMPageCount |
Specifies a Page Count field. |