Summarizing Data in the Active Report Output

You can add an output summary to a list or crosstab control that reflects the data that appears in the control when an active report is viewed.

About this task

You can add two types of summaries to an active report. The summaries that you can add to regular reports are also available in active reports. Output summaries are specific to active reports. Output summary values are calculated from the data that users see in the output. For example, an active report contains a check box group control and a list control. You add two summaries to the list. The first summary is the aggregation method Total that is available in all reports. The second summary is the output summary Total that is available only in active reports. The data that users see in the list is filtered by selecting items in the check box group control. The Total output summary value is calculated from the items that are selected in the check box group control. The value for the Total aggregation method that is available in all reports remains the same, regardless of what items are selected in the check box group control. This value is the total of all items in the list.

Only a subset of the aggregation methods that are available in all reports is available as output summaries.

Procedure

  1. In a list or crosstab, click the column or row for which you want to add an output summary.
  2. In the report object toolbar, click the summarize button Summarize button icon. and then, under Summarize in Output, choose the summary that you want to add to the active report output.
    Tip: After you add an output summary, you can specify a different aggregation method. Select the summary data item in the list or crosstab, click the Show properties icon Show properties icon, and for the Output summary property, choose the aggregation method that you want.