Filter
Top Products
Enhancing crosstabs
346 DataWindow .NET
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 anytime 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
338.
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.
DataWindow Designer changes the column name in the Source Data box
and anywhere else the column is used.