Use the Summary Details window to define columns as summary columns in a report. A summary column is a column whose values are either summed or counted. You can designate the summed and counted levels printed, and you can rename the default summary prompts.

The Summary Details window displays the report summary levels and the column grouping levels for the column that you select in the Column Details window.

The report summary levels are:

• Page Total Sum - The sum or count of records on the current page.

• Running Page Total - The sum or count of records up to and including the current page.

• Previous Page Total - The sum or count of records up to but not including the current page.

• Report Total Sum - The sum or count of records in the entire report.

The grouping levels displayed in the Summary Details window are all grouping levels up to, but not including, the grouping level for the selected column. For example, a report contains these grouping levels:

1 - Payment Currency

• 2 - Bank

  2 - Branch

  2 - Account

  3 - Date

  3 - Supplier Name

  3 - Supplier Site

  3 - Payment Method

  Invoice Number

  Invoice Amount

  Taxable Amount

If you print the number of suppliers (count on Supplier Name), the Supplier Name column shows six summary levels: four report summary levels, grouping level 1 (Payment Currency), and grouping level 2 (Bank, Branch, and Account).

If you print total purchases (sum on Invoice Amount), the Invoice Amount column shows seven summary levels: four report summary levels, grouping level 1 (Payment Currency), grouping level 2 (Bank, Branch, Account), and grouping level 3 (Date, Supplier Name, Supplier Site, Payment Method).

To define summary details for a column:

1. Navigate to the Attribute Set window.

2. In the Report Name field, choose the RXi report that you want.

3. In the Attribute Set field, enter the attribute set that you want.

4. Navigate to the Column Details window by pressing the Column Details button.

5. Select the column heading that you want, then navigate to the Summary Details window by pressing the Sum Details or Count Details button.

   Press the Sum Details button to summarize column values. This button is available for number columns only. Press the Count Details button to count column records. This button is available for all columns, since you can count the number of records in any column.

   The Summary Details window appears.

6. In the Prompt field, enter a new prompt name for a report summary level or grouping level to print in the report.

   You can include the interface table column name of another column in the prompt to create a dynamic prompt. For example, Total for [SOB_NAME].

   Note: If several columns share the same group level, summary function, and summary prompt, these columns are printed together on one line under one prompt.

7. Check the Display check box next to each report summary level and grouping level that you want to include in the report.

8. Return to the Column Details window. The Sum or Count check box is checked for the selected column.

9. Repeat steps 5 to 8 for each column that you want to summarize.