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:

Shown is an example of the cross tab where the text Product has been replaced by Printer Model.