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

About matrix objects

A matrix object merely defines a relationship between two repeating frames:   it isn't really owned by any object, nor does it own any object. A matrix object is created only for layouts with a Matrix layout style.   A report may have multiple matrices within it, provided that the data model contains the necessary groups.   Reports Builder creates one matrix object for each pair of intersecting, perpendicular repeating frames.

The repeating frames are the dimensions of the matrix and the matrix object contains the field that will hold the ”filler” or values of the cell group. One of the repeating frames must have the Print Direction property set to Down and the other must have the Print Direction property set to Across in order to form a matrix. 

Note: When running a JSP-based Web report that includes a matrix object, the JSP <rw:include> tag expects the matrix object to format on only one page. However, if the cells in the across repeating frame expand, the column headers of the matrix may be forced onto a second page regardless of the page size. Therefore, these matrix headers will not appear in the report output. Additionally, in this situation, the paper layout does not display correctly as header fields move to subsequent pages where the cell values remain on the first page. To resolve this, it is important to carefully define in the Report Editor the space available to the across repeating frame to allow for displaying the largest values, then set the Vertical Elasticity property of the across repeating frame to Fixed.

Restrictions

Example

Suppose that you have a group named Group1 that contains a column called C_DEPTNO, which gets its values from the database column DEPTNO. A group called Group2, contains column C_JOB, which gets its values from the database column JOB, and column C_DEPTNO1, which is used for linking to Group1's query. A group called Group3 contains a column called SUMSAL, which is a summary of the database column SAL.


                      Job
            Analyst  Clerk  Manager
			
        10           $1300   $2450
  Dept  20   $6000   $1900   $2975
        30           $ 950   $2850

In this example:

If you need to build a more complex matrix, you can do so by adding more columns to Group1 and Group2.   For example, instead of having Group1 just contain department numbers, it could also contain the locations (LOC) of the departments. The matrix might then look something like this:


                              Job
 Loc        Dept    Analyst  Clerk  Manager
 
 New York    10              $1300   $2450
 Dallas      20      $6000   $1900   $2975
 Chicago     30              $ 950   $2850

See also

About matrix reports

About matrix with group reports

About nested matrix reports

Creating a matrix object

Creating a matrix (cross-product) group

Creating a nested matrix report