Table Wizard for web report/library component

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

The wizard consists of the following screens:

• Data screen
• Display screen
• Group screen
• Summary screen
• Filter screen
• Style screen

Back

Goes back to the previous screen.

Next

Goes to the next screen.

Finish

Finishes creating or modifying the table 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 table. 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 data fields to display in the table. See the screen.

Title

Specifies the title of the table.

Resources

Lists all the available data resources.

Adds the specified field to use in the table.

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

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

Moves the specified field one step up.

Moves the specified field one step down.

Show Table Group Structure

Specifies whether to show the group structure of the table.

Display Fields

Lists the fields that you have selected to display in the table.

Display Name

Shows the display names of the selected fields. You can double-click the name cells to edit them if required.

Group screen

Specifies the fields that you want to use to group the data. See the screen.

Resources

Lists all the available data resources.

Adds the selected field as the group by field in the table.

Removes the selected group by field that is not required.

Replaces the selected group by field in the table with the specified field in the Resources box.

Moves the specified group one step up.

Moves the specified group one step down.

Group By

Lists the fields that are used to group data in the table.

Sort

Specifies how groups at the specific group level will be sorted.

• Ascend
  Groups will be sorted in an ascending order (A, B, C).
• Descend
  Groups will be sorted in a descending order (C, B, A).
• No Sort
  Groups will be sorted in the original order in database.

Select N

Opens the Select N dialog to specify the Select N condition.

Summary screen

Specifies the fields on which to create aggregate functions. This screen is available only when you create a table. See the screen.

Resources

Lists all the available data resources.

Adds the selected field as the summary field to the table.

Removes the selected summary field that is not required.

Moves the specified summary field one step up.

Moves the specified summary field one step down.

Summarized Fields

Lists all the fields that you want to display and to be summarized in the table.

Position

Works together with the Column option to specify the location where the summary field will be put.

• Header
  Specifies to put the summary field in the header row. If the summary is calculated on a group by field, it will be put in the group header row of the corresponding group; if the summary is calculated on the whole dataset, it will be put in the table header row.
• Footer
  Specifies to put the summary field in the footer row. If the summary is calculated on a group by field, it will be put in the group footer row of the corresponding group; if the summary is calculated on the whole dataset, it will be put in the table footer row.

Column

Works together with the Position option to specify the location where the summary field will be put.

• Detail
  The summary field will be put in a detail column.
• Summary
  The summary field will be displayed in a separate summary column.

Filter screen

Specifies to filter data displayed in the table. This screen is available only when you create a table. 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 options in the screen, see Edit Filter dialog.

Style screen

Specifies the style of the table. See the screen.

Grow Report

Specifies the layout of the table.

• Vertically
  Creates a vertical table.

Style

Lists the available styles.

• <Custom>
  There is no any style information on it and it is only used to cover previous-version report which did not bind any style or the bound style cannot be found in the style list.

Preview

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

Related topics:

• Creating a table report
• Modifying a table