Creating crosstabs

StepsTo create a crosstab:

  1. Select File>New>Other from the menu bar of the Web Application Development perspective. The Select a Wizard page opens.

  2. Expand Sybase and select DataWindow. Then, click Next. The New DataWindow Object wizard opens.

  3. In the Create DataWindow Object page, enter values for the following fields and click Next.

    Field

    Value

    DataWindow library

    Specify the library in which the DataWindow object is to be saved.

    DataWindow name

    Enter the name of the DataWindow object you want to create.

    Presentation style

    Choose Crosstab as the presentation style for the DataWindow object.

  4. In the Database Connection Profile page, select an existing database connection profile or create a new one. To create a new database connection profile, see Step 4 in “To create a new DataWindow library:.”

  5. In the Choose Data Source for Crosstab DataWindow page, specify the data you want retrieved into the DataWindow object.

    For more information, see “Building a DataWindow object.”

    You are prompted to specify the data for the columns, rows, and cell values in the crosstab.

  6. In the Define Crosstab Rows, Columns, Values page, enter the definitions for the columns, rows, and cell values in the crosstab.

    See “Associating data with a crosstab”.

  7. Click Next.

  8. In the Select Color and Border Settings page, click Color and Border settings and click Next.

  9. In the Ready to Create Crosstab DataWindow page, review your specifications and click Finish.

    Sybase WorkSpace creates the crosstab.

  10. (Optional) Specify other properties of the crosstab.

    See “Enhancing crosstabs”.




Copyright © 2007. Sybase Inc. All rights reserved. Associating data with a crosstab