Create Crosstab wizard for web report/library component

This wizard appears when you click Insert > Crosstab on the menu bar, click the Insert Crosstab button on the Insert toolbar, or drag Crosstab from the Toolbox panel into a web report or library component. It helps you to create a crosstab in a web report or library component, and consists of the following screens:

Back

Goes back to the previous screen.

Next

Goes to the next screen.

Finish

Finishes creating the crosstab and closes this dialog.

Cancel

Does not retain changes and closes this dialog.

Help

Displays the help document about this feature.

Data screen

Specifies the data source that you want to use to create 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 that you want to display in the crosstab. See the screen.

Title

Specifies the title of the crosstab.

Resources

Lists all the available data resources. You can also create dynamic formulas and aggregations to use in the crosstab.

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.

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. 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

Specifies the style of the crosstab.

Preview

Shows a sketch of the selected style.

Related topics: