Previous Topic  Next Topic

Crosstab Wizard Properties

You can use the Crosstab Wizard dialog box to create a crosstab report. This topic describes the properties in the dialog box.

This topic contains the following sections:

• Data Screen
• Display Screen
• Dataset Filter Screen
• Style Screen

Back

Select to go to the previous screen.

Next

Select to go to the next screen.

Finish

Select to create the crosstab and exit the wizard.

Cancel

Select to close the wizard without creating a crosstab.

Help

Select to view information about the dialog box.

Data Screen

Specify the business view or dataset you want to use to create the crosstab. Server hides this screen when there is only one business view or dataset in the current catalog.

Available Data Resources

Select a business view or dataset in the current catalog, using which you want to create the crosstab.

• Inherit from the Parent
  Select if you want the data component to inherit the dataset of the parent object. Available only when you are inserting the data component into any of the following panels in a banded object: banded header panel, banded footer panel, group header panel, and group footer panel.

Back to top

Display Screen

Specify the fields to display in the crosstab.

Resources

Server displays the view elements in the selected business view or the business view of the selected dataset. Select a non-folder resource.

Add button

Select to add the selected group object to display on the column header of the crosstab.

Add button

Select to add the selected group object to display on the row header of the crosstab.

Add button

Select to add the selected aggregation object to be the aggregate field of the crosstab.

Columns/Rows

• Field
  Server lists the group objects you added to display on the column/row headers of the crosstab.
• Display Name
  Specify the labels for the column/row headers. You can select a text box to edit the label, or select the Auto Map Field Name checkbox beside the text box to automatically map the label to the dynamic display name of the object.
• Sort
  Select the sort order of the group objects.
• Add Compound Group button
  Select to add a column/row compound group.

Summaries

• Field
  Server lists the aggregation objects you added as the aggregate fields of the crosstab.
• Display Name
  Specify the labels for the aggregations. You can select a text box to edit the label, or select the Auto Map Field Name checkbox beside the text box to automatically map the label to the dynamic display name of the object.

Move Up button

Select to move the selected field or compound group higher in the list. For fields in a compound group, you can only change their order within the current group.

Move Down button

Select to move the selected field or compound group lower in the list. For fields in a compound group, you can only change their order within the current group.

Remove button

Select to remove the selected field or compound group that you do not want in the crosstab.

Back to top

Dataset Filter Screen

Specify the filter that you want to apply to the dataset of the crosstab.

Server displays the predefined filters of the business view in the Filter list. You can choose one of them to apply. If you prefer to define a filter on your own, select User Defined from the list, and then define it.

If the selected business view contains parameters, Server displays the Enter Parameter Values dialog box for you to specify the parameter values before displaying the Dataset Filter screen.

For more information, see the Edit Dataset Filter dialog box.

Back to top

Style Screen

Specify the style of the crosstab. Server hides this screen when there is only one style available to the crosstab.

Style

Select a style you want to apply to the crosstab.

Inherit Style

Select to take the style of the parent component. The property is available when you insert the crosstab into a banded object.

Preview

Server shows a preview of the crosstab in the selected style.

Back to top

Previous Topic  Next Topic