Specifications

Enhancing crosstabs
444 InfoMaker
Modifying the data associated with the crosstab
When you initially define the crosstab, you associate the crosstab rows and
columns with columns in a database table or other data source. You can change
the associated data at any time in the Crosstab Definition dialog box.
❖ To open the Crosstab Definition dialog box:
1 Position the mouse below the footer band in the workspace and display the
pop-up menu.
2 Select Crosstab from the pop-up menu.
The Crosstab Definition dialog box displays.
❖ To modify the data associated with a crosstab:
1 In the Crosstab Definition dialog box, fill in the boxes for Columns, Rows,
and Values as described in “Associating data with a crosstab” on page
436.
2 Click OK.
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.
❖ To 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.
InfoMaker 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.