Changing the names used for the columns and rows

Sometimes names of columns in the database might not be meaningful. You can change the names that are used to label rows and columns in crosstabs so that the data is easier to understand.

StepsTo change the names used in crosstabs:

  1. In the Crosstab Definition dialog box, double-click the name of the column in the Source Data box.

    The New Name dialog box displays:

  2. Specify the name you want used to label the corresponding column. You can have multiple-word labels by using underscores: underscores are replaced by spaces in the Design view and at runtime.

  3. Click OK.

    PowerBuilder changes the column name in the Source Data box and anywhere else the column is used.

Example

For example, if you want the product column to be labeled Printer Model, double-click product in the Crosstab Definition dialog box and specify printer_model in the New Name dialog box.

When the crosstab runs, you see this:

The sample has the headings Sum of Units and Quarter. Below them is a column heading for Printer Model, a column heading for each quarter, and a grand total for each product row. At the bottom of the crosstab are grand totals for all products for each column that represents a quarter. Data is shown for three sample printer models, Cosmic, Galactic, and Stellar.