fyiReporting Software, LLC
Cross tabulate data (matrix)
To create a matrix click on the Matrix toolbar item and then click into the body of the report. This will bring up the Matrix wizard as described below.
Select the DataSet you want to use. The columns in that DataSet will appear in the DataSet Fields list. You'll need to create a new DataSet using the menu Data/DataSets/New... before creating the matrix if the datasets available don't provide the information you need.
Pick the fields for the Matrix columns by clicking on a DataSet Field and hitting the > button next to the Columns list. When you run the report each unique data value will create a column.
Pick the fields for the Matrix rows by clicking on a DataSet Field and hitting the > button next to the Rows list. When you run the report each unique data value will create a row.
Pick the Matrix Cell Expression by choosing from the drop down list box or by editting. The drop down list box is populated with Sum expressions for each field in the DataSet that hasn't been picked for a Column or Row. However, you can edit the expression after picking one. For example, you might want to change "=Sum(Fields!Region.Value)" to "=Count(Fields!Region.Value)".