Creating crosstabs  Specifying the information

Chapter 14: Working with Crosstabs

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.

    The sample is titled Define Crosstab Rows, Columns, Values. On the left are icons representing a general variety of crosstabs. On the right are four boxes listing Source Data, Columns, Rows, and Values. Above them is the prompt "Define your rows, columns, and values for your data window:" The Source data box includes rep, quarter, product, and units. Under Columns is the quarter column. Under Rows is the product row. Under Values is the expression sum( units for cross tab ). At the bottom is a selected check box labeled Rebuild columns at runtime.

  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 box is selected.

    For information about static crosstabs, see “Creating static crosstabs”.

  4. Click Next.




Copyright © 2006. Sybase Inc. All rights reserved. Specifying the information

View this book as PDF