You associate crosstab columns, rows, and cell values with columns in a database table or other data source.
To associate data with a crosstab:
If you are defining a new crosstab, the Define Crosstab Rows, Columns, Values dialog box displays after you specify the data source.
-
Specify the database columns that will populate the columns, rows, and values in the crosstab, as described below.
-
To build a dynamic crosstab, make sure the Rebuild columns at runtime check box is selected.
For information about static crosstabs, see Creating static crosstabs.
-
Click Next.