### Crosstab Wizard

This wizard guides you through the process of creating a crosstab. It contains the following screens:

- Data screen
- Display screen
- Query Filter screen
- Style screen

Back

Returns to the previous tab.

Next

Goes to the next tab.

Finish

Creates the crosstab and closes the wizard.

Cancel

Closes the wizard without creating a crosstab.

Help

Displays the help document about this feature.

#### Data screen

Specifies the business view to use to create the crosstab. This screen is hidden when there is only one business view in the current catalog. See the screen.

Available Data Resources

Lists all the available business views in the current catalog, with which you can create the crosstab.

#### Display screen

Specifies the fields to be displayed in the crosstab. See the screen.

Resources

Displays the view elements in the selected business view. Select one non-folder resource each time and then click a proper arrow button to add it into the corresponding box.

Adds the selected group object to be displayed on the columns of the crosstab.

Adds the selected group object to be displayed on the rows of the crosstab.

Adds the selected aggregation object to be the aggregate field of the crosstab.

Columns/Rows

- Field
  Lists the group objects that will be displayed on the columns/rows of the crosstab.
- Display Name
  Specifies the display names of the group objects. By default these are blank and no labels will be created for the group objects to name the columns/rows. You can click the cells to edit them if required.
- Sort
  Specifies the sort order of the group objects.

Summaries

- Field
  Lists the aggregation objects that will be the aggregate fields of the crosstab.
- Display Name
  Specifies the display names of the aggregation objects. By default these are blank and no labels will be created for the aggregation objects to name the summaries. You can click the cells to edit them if required.

Moves the selected resource one level up. The order here defines the order of the resources displayed in the crosstab from left to right or from top to bottom.

Moves the selected resource one level down. The order here defines the order of the resources displayed in the crosstab from left to right or from top to bottom.

Removes the selected resource from the crosstab.

#### Query Filter screen

Specifies the filter which you want to apply to the selected business view. See the screen.

In this screen, all the predefined filters of the business view are listed in the Query Filter drop-down list. You can choose one of them to apply. If you prefer to define a filter on your own, select User Defined from the drop-down list, and then define it according to your requirements.

For details about options in the screen, refer to Query Filter dialog.

#### Style screen

Specifies the style of the crosstab. This screen is hidden when there is only one style available to be applied to the crosstab. See the screen.

Style

Lists all the available styles for you to select from.

Inherit Style

Specifies to take the style of the parent component. The option is available only when you specify to insert the crosstab into a banded object.

Preview

Shows a preview of the selected style.

###### Related topics:

- Creating a crosstab report