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:
When you click the Change Summary button for a summarized field in the Cross-Tab Expert.
When you click the Set Summary Operation button on the Data tab (Map Expert) of the Chart Expert or Map Expert.
The Set Summary Operation button is available for charts and maps with an Advanced layout type. You must move a field to the "values" list and select it in order to activate the button.
Note
Map objects are not supported in this version of Crystal Reports.
| 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. |