This dialog appears when you right-click the Summaries node in the Data tab of the Catalog Browser and select Add Summary from the shortcut menu. It helps you to create a summary in a catalog. See the dialog.
The following are details about options in the dialog:
Resource
Lists all the available resources that can be used to make a summary.
Summaries
By default, <Create...> is selected in the drop-down list. You can also select one of the existing summaries from the drop-down list for modifying it.
Aggregate Function
Lists the functions which are available to the selected field. For details about each function, see Math functions.
Summary On
Specifies the field on which the summary is to compute.
To specify the sum on field, highlight it in the Resource box and then click next to Summary On to add it to the field box.
Static Summary
If selected, the summary will take effect on a specific group that you define in the Group By field and it can only be inserted into the group.
To specify the group by field, highlight it in the Resource box and then click next to Group By to add it to the field box.
Dynamic Summary
If selected, the summary will take effect on the group according to the number, which is specified in the Group By field and it can be inserted into any groups of a component.
To specify the group level, first select Up or Down from the drop-down list, then in the combo box, select a value or input an integer, which should be between 0 to 127, to specify the group on which the summary will take effect. For example, if you select Up or Down and input 0 in the combo box and insert this summary into any group, the summary will take effect on this group; if you select Up and input 1 and insert this summary to a group, the summary will take effect on the group higher than the group where the summary is inserted, and if you specify Down and 1, it will take effect on the lower group; and the rest may be deduced by analogy.
Notes:
Special Function
If the group by field is of Numeric/String/Date/Time type, you can select a special function for the field in the Special Function drop-down list to further specify to which level the data will be grouped by. If Customize is selected, the Customized Function dialog will be displayed, in which you can set the function by your own.
OK
Accepts all changes and closes the dialog.
Apply
Applies all changes to the existing summary or adds the new summary to the catalog.
Cancel
Does not retain any changes and closes this dialog.
Help
Displays the help document about this feature.