You can use the Edit Summary dialog box to edit a summary. This topic describes the options in the dialog box.
Designer displays the Edit Summary dialog box when you right-click a summary and select Edit Summary from the shortcut menu in the Catalog Manager or in the Data panel.
You see the following options in the dialog box:
This box lists all the available resources that you can use for the summary.
This option shows the name of the summary. You can also choose to create a new summary or edit another one by selecting <Create...> or the name of the summary from the drop-down list.
This drop-down list contains the aggregate functions that you can use to compute the selected field. Select the function you need.
- Distinct On
Designer enables this option and you should set it when you select DistinctSum as the aggregate function. Select the ellipsis to select the fields according to whose unique values to calculate DistinctSum in the Select Fields dialog box.
Specify the field on which the summary is to compute. To specify the field, select it in the Resource box and then select beside Summary On to add it to the text box.
Select it if you want the summary to take effect on a specific group that you define in the Group By text box.
- Group By
Specify the field by which to group the data. To specify the group-by field, select it in the Resource box and then select beside Group By to add it to the text box.
Select it if you want the summary to take effect on the group according to the number that you specify in the Group By text box.
- Group By
Specify on which group you want the summary to take effect. To specify the group level, first select Up or Down from the drop-down list, then in the combo box, select a value or type an integer between 0 to 127.
If the group-by field is of the Numeric, String, Date, or Time data type, you can select a special function for the field from the drop-down list to further specify to which level to group the data. If you select Customize, Designer displays the Customized Function dialog box for you to set the function.
Select to apply your settings and close the dialog box.
Select to close the dialog box without saving any changes.
Select to apply all changes and leave the dialog box open.
Select to view information about the dialog box.