Insert Crosstab dialog

This dialog appears when you click Menu > Insert > Crosstab, or drag Crosstab from the Components panel to the destination. It helps you to insert a crosstab to a report. See the dialog.

Crosstab Title

Specifies a title for the crosstab.

Sets the font, font style, size, alignment, font color and background color properties for the crosstab title.

Data Source

Specifies a data source on which the crosstab will be built from the data source drop-down list.

Filter

Opens the Query Filter dialog to specify the filter which you want to apply to the selected business view.

Resources

Displays the elements in the selected business view.

Edits the selected dynamic resource.

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

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

Adds the selected aggregation object or detail object to be the summary field of the crosstab.

Columns/Rows

• Field
  Lists the group objects that will be displayed in the columns/rows of the crosstab.
• Label
  Specifies the display names for the selected group objects.
• Sort
  Specifies the sort order of the group objects.

Summaries

• Field
  Lists the fields that you select to create summaries.
• Label
  Specifies the display names for the selected fields.
• Aggregation
  Specifies the functions used to summarize data of the selected detail objects.

Moves the selected view element one level up.

Moves the selected view element one level down.

Removes the selected resource.

OK

Inserts a crosstab and closes the dialog.

Cancel

Cancels the insertion and closes the dialog.

Help

Displays this help document.