Associating data with a crosstab

You associate crosstab columns, rows, and cell values with columns in a database table or other data source.

StepsTo associate data with a crosstab:

  1. If you are defining a new crosstab, the Define Crosstab Rows, Columns, Values dialog box displays after you specify the data source.

    Shown is the Define Cross tab Rows, Columns, Values dialog box.
  2. Specify the database columns that will populate the columns, rows, and values in the crosstab, as described below.

  3. 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”.

  4. Click Next.