Data Summary Types
When rendering a cross-table, the report generator should know how the values in the summary cells will be summarize. Summation function is set using the Summary property of a summary cell. For each summary cell its own function can be specified. A Cross Table works with the following functions:
Function |
Description |
None |
Do not summarize the cell values |
Sum |
Returns the sum of values that are contained in the cell |
Average |
Returns the average of values that are contained in the cell |
Min |
Returns the minimal of values that are contained in the cell |
Max |
Returns the maximal of values that are contained in the cell |
Count |
Returns the number of values that are contained in the cell |
CountDistinct |
Returns the number of distinct values that are contained in the cell |
Image |
A cross table will show the first value as an image |
In addition to the Summary property, there is another property that affects on the summary. This is the Summary Values property. This property identifies and process the 0 and null values when calculating totals.