Previous Page Next Page
The wizard helps you to create a page report tab with a table in it, create a library component with a table in it, or edit an existing table in a report. It varies with the data resource type used by the table: business view or query resource.
Back
Goes back to the previous screen.
Next
Goes to the next screen.
Finish
Finishes creating or editing the table and closes this wizard.
Cancel
Does not retain changes and closes this wizard.
Help
Displays the help document about this feature.
When the wizard is used in a web report/library component, the screens available in the wizard vary according to the table type: group table and summary table.
When the wizard is used for creating/editing a table in a page report or creating/editing a group table in a web report/library component using a business view, it consists of the following screens: Data, Display, Group, Summary, Filter and Style.
The screen lists all the predefined business views in the current catalog. Select the one you want to use for the table.
Inherit from the Parent
Specifies to inherit data from the business view used by the parent object. Available only when the table is in any of the following panels in a banded object in a web report: banded header panel, banded footer panel, group header panel and group footer panel.
Specifies the detail fields to display in the table.
Title
Specifies the title for the table.
Resources
Lists the resources in and related to the specified business view, which can be used as detail fields in the table.
Adds the selected field in the Resources box to the table.
Removes the selected field from the table.
Replaces the selected field in the table with the specified field in the Resources box. Available only when editing a table.
Moves the selected field one step up. Available only when creating a table.
Moves the selected field one step down. Available only when creating a table.
Show Table Group Structure
Specifies whether to show the group structure of the table. Available only when editing a table.
Display Fields
Lists the detail fields of the table.
Display Name
Specifies the text of the labels of the detail columns, which by default are the display names of the added fields. You can click in the text boxes to edit the label text, or check the Auto Map Field Name checkboxes in the text boxes to automatically map the label text to the dynamic display names of the fields at runtime.
Sort Fields By
Opens the Sort Fields By dialog to specify how to sort the detail data in the table.
Specifies the criteria for grouping data in the table.
Resources
Lists the resources in and related to the specified business view, which can be used as group-by fields in the table.
Adds the selected field in the Resources box as a group-by field in the table.
Removes the selected group-by field from the table.
Replaces the selected group-by field in the table with the specified field in the Resources box. Available only when editing a table.
Moves the selected group one step up.
Moves the selected group one step down.
Group By
Lists the group-by fields of the table.
Sort
Specifies how groups at the specific group level will be sorted.
Select N
Opens the Select N dialog to specify the Select N condition.
Specifies the summaries to calculate data in the table. This screen is available only when you create a table.
Resources
Lists the resources in and related to the specified business view, which can be used to calculate data in the table.
Adds the selected field to calculate data in the table.
Removes the selected summary from the table.
Moves the selected summary one step up.
Moves the selected summary one step down.
Summarized Fields
Lists the fields added to calculate data in the table.
Position
Works together with the Column option to specify the location where a summary will be put.
Column
Works together with the Position option to specify the location where a summary will be put.
Specifies to filter data displayed in the table. This screen is available only when you create a table, and it contains the same options as those in the Edit Filter dialog.
Specifies the style of the table.
Grow Report
Specifies the layout of the table, which can only be Vertically. Available only when creating a table.
Style
Specifies the style of the table.
Preview
Displays the selected layout and style effects.
Inherit Style
Specifies whether to make the table take the style of its parent. This option is available only when you edit a table and the table is inserted into a banded object of a page report.
Page Setup
Opens the Page Setup dialog to specify the page settings. Available only when creating a table in a page report.
When the wizard is used for creating/editing a summary table in a web report/library component using a business view, it consists of the following screens: Data, Columns, Summary, Filter and Style.
The screen lists all the predefined business views in the current catalog. Select the one you want to use for the table.
Inherit from the Parent
Specifies to inherit data from the business view used by the parent object. Available only when the table is in any of the following panels in a banded object in a web report: banded header panel, banded footer panel, group header panel and group footer panel.
Specifies the fields to create the columns of the table.
Resources
Lists the resources in and related to the specified business view, which can be used to create the columns in the table.
Adds the selected field in the Resources box to create a column in the table.
Removes the selected field from the table.
Replaces the selected field in the table with the specified field in the Resources box. Available only when editing a table.
Moves the selected field one step up.
Moves the selected field one step down.
Column
Lists the columns of the table.
Sort
For a group column you can specify how groups at the specific group level will be sorted.
Select N
Opens the Select N dialog to specify the Select N condition for a group column.
Specifies to insert summaries to the header/footer panels of the table and groups.
Resources
Lists the aggregation objects that have been added to the table in the Columns screen.
Summarized Fields
Displays the group objects that have been added to the table in the Columns screen.
Header
Represents the table header or the group header of a specific group. After an object is selected in the Resources box, you can select the checkboxes in the column to insert it in the corresponding header panels.
Footer
Represents the table footer or the group footer of a specific group. After an object is selected in the Resources box, you can select the checkboxes in the column to insert it in the corresponding footer panels.
Specifies to filter data displayed in the table. This screen is available only when you create a table, and it contains the same options as those in the Edit Filter dialog.
Specifies the style of the table.
Grow Report
Specifies the layout of the table, which can only be Vertically. Available only when creating a table.
Style
Specifies the style of the table.
Preview
Displays the selected layout and style effects.
When the wizard is used to create/edit a table using a query resource, it consists of the following screens: Data, Display, Group, Summary, Chart, Filter and Style.
Specifies the dataset of the table.
Data resource box
Lists the predefined data resources in the current catalog. Select one and a dataset based on it is created automatically for the table.
More Options/Less Options
Shows or hides the dataset selection panel to choose a dataset for the table.
Specifies the detail fields to display in the table.
Resources
Lists the data fields in and related to the specified query resource, which can be used as detail fields in the table.
Adds the selected field in the Resources box to the table.
Removes the selected field from the table.
Replaces the selected field in the table with the specified field in the Resources box. Available only when editing a table.
Moves the selected field one step up. Available only when creating a table.
Moves the selected field one step down. Available only when creating a table.
Show Table Group Structure
Specifies whether to show the group structure of the table. Available only when editing a table.
Display Fields
Lists the detail fields of the table.
Display Name
Specifies the labels of the detail columns, which by default are the display names of the added fields. You can click in the text boxes to edit the labels if required.
Sort Fields By
Opens the Sort Fields By dialog to specify how to sort the detail data in the table.
Specifies the criteria for grouping data in the table.
Resources
Lists the data fields in and related to the specified query resource, which can be used as group-by fields in the table.
Adds the selected field in the Resources box as a group-by field in the table.
Removes the selected group-by field from the table.
Replaces the selected group-by field in the table with the specified field in the Resources box.
Moves the selected group one step up.
Moves the selected group one step down.
Group By
Lists the group-by fields of the table.
Sort
Specifies how groups at the specific group level will be sorted.
Special Function
For a group-by field of the Numeric/String/Date/Time type, you can select a special function for it to specify to which level data will be grouped by. Select Customize to set the function in the Customized Function dialog.
Custom Sort
Specifies how to sort the groups. Activated only when you have clicked Custom Sort from the Sort column to define the sorting manner of groups for the selected group level.
Special Group
Specifies how to group your information. Activated only when you have clicked Special Group from the Sort column to define a special group.
Select N
Opens the Select N dialog to specify the Select N condition.
Group Filter
Opens the Group Filter dialog to specify the group filter condition.
Specifies the fields on which to create aggregate functions. This screen is available only when you create a table.
Resources
Lists the data fields in and related to the specified query resource, which can be used to create summaries in the table.
Adds the selected field in the Resources box based on which to create a summary in the table.
Removes the selected summary from the table.
Moves the selected summary field one step up.
Moves the selected summary field one step down.
Summarized Fields
Lists the fields that have been added to create summaries in the table.
Aggregate Function
Specifies the aggregate functions used for the summaries.
Break Field
Displays the groups on which the summaries will be calculated. If a summary is added for the Table level, the break field is null and the summary will be calculated on the whole dataset.
Position
Works together with the Column option to specify the location where the summary field will be put. Not available when the table type is Group Above.
Column
Works together with the Position option to specify the location where the summary will be placed.
Specifies to create a chart together with the table, which will be placed above the table in the report body. This screen is available only when you create a table, and when there is at least one group and one summary added for this group in the table.
No Chart
Specifies not to create a chart.
Bar Chart
Specifies to create a Clustered Bar 2-D chart together with the table.
Line Chart
Specifies to create a Line 2-D chart together with the table.
Pie Chart
Specifies to create a Clustered Pie chart together with the table.
Category
Lists the group-by fields of the table on which summaries are added. Choose the field you want to display on the category (X) axis of the chart from the drop-down list.
Series
Lists the fields that have been added as the group-by fields of the table. Choose the field you want to display on the series (Z) axis of the chart from the drop-down list.
Show Values
Lists the summaries which are calculated based on the field you choose to display on the category axis of the chart. Choose the value you want to display in the chart from the drop-down list.
Specifies to filter data displayed in the table. This screen is available only when you create a table, and it contains the same options as those in the Edit Filter dialog.
Specifies the style of the table.
Grow Report
Specifies the layout of the table. Available only when creating a table.
Style
Specifies the style of the table.
Preview
Displays the selected layout and style effects.
Inherit Style
Specifies whether to make the table take the style of its parent. This option is available only when you edit a table and the table is inserted into a banded object.
Page Setup
Opens the Page Setup dialog to specify the page settings. Available only when creating a table.