To create a summary column (for totals or subtotals) using the Data Wizard:
In the Data Model view, click the query that contains the column you want to total.
Choose ToolsData
Wizard.
Note: For group reports, the Report Wizard and Data Wizard create 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).
To create a summary column (for totals or subtotals) using the tool palette:
In the Data Model view, single-click in the tool palette,
then:
To create a column within a group, click in the group at the position you want the column placed in the hierarchy.
To create a report-level column, click in an open area of the canvas region.
Double-click the summary column object to display the Property Inspector.
Under the Summary node:
Set the Function property by choosing the type of summary you want from the list.
Set the Source property to the column you want to summarize.
Set the Reset At property to the group at which the summary column value resets.
For JSP-based Web reports with a Group Above or Matrix style, if any summary column values are not correctly left-aligned when you click the Run Web Layout button, you can implement the following workaround to align the values:
In the Web Source view, locate the section where the summary column
is defined, and delete the following line to remove the extra space:
<th class="summary_column_name"> </th>
http://www.oracle.com/technology/documentation/reports.html
):
Building a Summary Report
Building a Group Left Summary Report
Creating or editing a placeholder column
Creating or editing a formula column
Copyright © 1984, 2005, Oracle. All rights reserved.