A matrix with group report is a group above report with a separate matrix for each value of the master group. For example, for each year (master) in the report below there is a unique matrix that contains only that years departments and jobs. This means that a summary of each job category may not line up with the values it summarizes because the position of each job category in the matrix may vary for each year.
A multiquery matrix with group report is similar to a nested matrix report in that it has more than two dimensions. For example, in the report below, notice that for each year there is a nested list of related departments.
The advantage of using multiple queries is that you get a real break, or master/detail relationship, for the nesting groups (for example, notice that in the multiquery example above, Year 80 shows only record 20; with a single query, Year 80 would show all records whether or not they contain data for Year 80). If you want to suppress detail records that do not contain data for a particular master record, you must use multiple queries.
For a detailed example, see the chapter "Building a Matrix with Group
Above Report" in the Oracle Reports Building Reports manual, available
on the Oracle Technology
Network Oracle Reports Documentation page (http://www.oracle.com/technology/documentation/reports.html
).
Creating a matrix (cross-product) group
Creating a nested matrix report
Offsetting detail objects in a group report
Copyright © 1984, 2005, Oracle. All rights reserved.