Crosstab Wizard for web report/library component

This wizard is displayed when you select Crosstab in the component type box and click OK in the New Library Component dialog, or right-click a crosstab and select Crosstab Wizard from the shortcut menu. It helps you to create or modify a crosstab in a web report or library component.

The wizard consists of the following screens:

Back

Goes back to the previous screen.

Next

Goes to the next screen.

Finish

Finishes creating or modifying the crosstab and closes this wizard.

Cancel

Does not retain changes and closes this wizard.

Help

Displays this help document.

Data screen

Specifies the business view used by the crosstab. See the screen.

Available data resources

Lists all the business views in the current catalog. Specify the one you want to use.

Display screen

Specifies the fields to display in the crosstab. See the screen.

Title

Specifies the title of the crosstab.

Resources

Lists all the available data resources.

Adds the selected field to be displayed on the columns of the crosstab.

Adds the selected field to be displayed on the rows of the crosstab.

Adds the selected field on which to create summaries.

Replaces the selected field in the crosstab with the specified field in the Resources box.

Columns/Rows

Summaries

Specifies in which manner to sort the field values.

Moves the specified field one step up.

Moves the specified field one step down.

Removes the specified field that is not required in the crosstab.

Filter screen

Specifies to filter data displayed in the crosstab. This screen is available only when you create a crosstab. See the screen.

Filter

It lists all the predefined filters of the specified business view. Select one from the drop-down list to apply, or select User Defined and define a new filter according to your requirements.

For details about the other options in the screen, see Edit Filter dialog.

Layout screen

Specifies the layout of the crosstab. See the screen.

Aggregate

Specifies properties of the aggregate fields.

Suppress Row Grand Totals

Specifies whether or not to show the grand totals of rows.

Suppress Column Grand Totals

Specifies whether or not to show the grand totals of columns.

Suppress Row Subtotal

Specifies whether or not to show the subtotals of rows. If required, you can click to open the Suppress Row Subtotal dialog to specify which subtotals of the rows will be suppressed, and which will be shown.

Suppress Column Subtotal

Specifies whether or not to show the subtotals of columns. If required, you can click to open the Suppress Column Subtotal dialog to specify which subtotals of the columns will be suppressed, and which will be shown.

Note: The settings of the above four options will only take effect in view mode.

Repeat Column Header

Specifies whether or not the header of column will be appeared on every page, if a crosstab spans more than one page.

Table Style

Specifies whether or not to make the crosstab look like a table.

Column Total on

Specifies the position of total columns on the top or bottom of the aggregate.

Row Total on

Specifies the position of total rows on the left or right of the aggregate.

Preview

Displays a preview of the selected layout.

Style screen

Specifies the style of the crosstab. See the screen.

Style

Lists the available styles.

Preview

Displays a diagram illustrating the effect of the selected style on the crosstab.

Related topics: