Groups are created to organize the columns in your report. Groups can do two things: separate a querys data into sets, and filter a querys data.
When you create a query, Reports Builder automatically creates a group that contains the columns selected by the query. You create additional groups to produce break levels in the report, either manually in the Data Model view or by using the Report Wizard to create a group above or group left report.
Create groups when you want to treat some columns differently than others. For example, you create groups to:
produce subtotals (that is, totals at a more granular level)
create breaks or cross products in your report output
With the exception of cross-product groups, all user-created groups are called break groups.
You create break groups to produce subtotals, print columns in a different direction, create breaks, and so on. A break group suppresses duplicate values in sequential records. For example, Reports Builder can select the department number for each record; however, the duplicate department numbers are not printed.
You create cross-product groups to perform mathematical cross products, which are generally used to create matrix reports.
Filters enable you to conditionally remove records selected by your queries. Groups can have two types of filters:
Reports Builder packaged filters :
First
, to display only
the first n records for the group (for example, the first 5 records)
Last
, to display only
the last n records for the group
User-created filters, using PL/SQL.
About matrix with group reports
Creating a multiquery group above report
Creating a matrix (cross-product) group
Copyright © 1984, 2005, Oracle. All rights reserved.