Totals fields are placed at the end of the report. The count function can be used on any type of field but the remainder of the functions require a numeric field.
To calculate totals, averages, minimums, maximums, percent of the total value of a column, and count the number of times a value appears in the column:
Click a field in the Available Fields list.
Click the appropriate button for the function you want to apply to the field. An entry with the field and function name appears in the Totals list.
Repeat Step 2 for any other desired functions you want to apply to the field.
Repeat Steps 1 through 3 until you have created all of the desired totals.
(Optional) To remove a field from the Totals
list, click it then click .
Not
all Oracle database datatypes are supported at this time. will identify the datatype as unknown in the wizard if your
query selects an unsupported Oracle database datatype.
The functions you can perform on column objects and Ref columns are limited. Therefore, some functions are disabled when you select them in the Available Fields list.
For group reports, the Data Wizard creates n summary fields in the data model for each summary column you define: one at each group level above the column being summarized, and one at the report level. For example, if a report is grouped by division, and further grouped by department, then a summary column defined for a salary total would create fields for the sum of salaries for each division and each department group (group-level summaries), and the sum of all salaries (report-level summary).
Copyright © 1984, 2005, Oracle. All rights reserved.