Crystal Reports  

Edit Summary Dialog Box

Use the Edit Summary dialog box to set or change the summary operation for the selected field.

This dialog box appears when you select a summary field on a report, right-click it, and select the Change Summary Operation command from the shortcut menu. The command is also available when you:

Choose the field to summarize
This list displays the fields and formulas used in the report along with the fields available in the report's data source tables. Select the field that you want to summarize.
Calculate this summary
This list contains all the summary operations available for use in your report. Select the desired operation.
Note   Not all the summary types available apply to all fields. For example, you cannot sum or average a text, Boolean, date/time, time, or date field.
Show as a percentage of
Select this check box if you want to calculate the percentage total of one group within a broader grouping. For example, you can show the percentage of sales in each city based on the total sales for each country.

After you select the check box, you can choose the total or group you want the comparison to be based on.

Note   The percentage option is available only when the result of a summary operation is numeric.
Summarize across hierarchy
This option enables you to calculate a summary across hierarchical groupings. To set or edit Hierarchical Options for existing groups, click Hierarchical Grouping Options on the Report menu.

See Also

Insert Summary Dialog Box | Summarizing Grouped Data