A script-enabled browser is required for this page to function properly.

About matrix with group reports

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 year’s 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.

matrix with group

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).

See also

About nested matrix reports

Creating a report

About groups

About matrix objects

About matrix reports

Creating a matrix object

Creating a matrix (cross-product) group

Creating a nested matrix report

Offsetting detail objects in a group report

Creating a break group