Previous Topic
Create Table Dialog (for Web Report and Library Component)
The Create Table dialog for web report and library component appears when you choose a table type and select OK in the Table Type dialog, or drag the desired table type button from the Components panel into a web report. It helps you to create a table in a web report/library component.
The wizard is different according to the following table types:
For Group Left, Group Above and Group Left Above
The wizard consists of the following screens:
Back
Goes back to the previous screen.
Next
Goes to the next screen.
Finish
Finishes creating the table and closes this dialog.
Cancel
Does not retain changes and closes this dialog.
Help
Displays the help document about this feature.
Data
Specifies the data source that you want to use to create 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
Specifies the fields that you want to display in the table. See the screen.
Title
Specifies the title of the table.
Resources
Lists all the available data resources. You can also create dynamic formulas to use in the table.
Adds the specified field to use in the table.
Removes the specified field that is not required in the table.
Moves the specified field one step up.
Moves the specified field one step down.
Display Fields
Lists the fields that have been selected to display in the table.
Display Name
Shows the display names of the selected fields. You can select the name cells to edit them if required.
Sort Fields By
Opens the Sort Fields By dialog to specify how to sort data in the table.
Group
Specifies the fields that you want to use to group the data. See the screen.
Resources
Lists all the available data resources. You can also create dynamic formulas to use in the table.
Adds the selected field as the group by field in the table.
Removes the selected group by field that is not required.
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. - Custom Sort
Opens the Custom Sort dialog to set how groups will be sorted.
Select N
Opens the Select N dialog to specify the Select N condition.
Summary
Specifies the fields on which you want to create aggregate functions. See the screen.
Resources
Lists all the available data resources. You can also create dynamic formulas and aggregations to use in the table.
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. Not available when the table type is Group Above.
- 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. Not available when the table type is Group Above.
- Detail
The summary field with its label will be put in in the first two detail columns. - Summary
The summary field will be displayed in a separate summary column.
Filter
Specifies to filter data displayed in the table. See the screen.
The options in the screen are the same as those in the Edit Filter dialog.
Style
Specifies the style of the table. See the screen.
Grow Report
Specifies the layout of the table.
- Vertically
Creates a vertical table.
Style
Specifies the style of the table.
Preview
Displays the selected layout and style effects.
For Summary Table
The wizard consists of the following screens:
Back
Goes back to the previous screen.
Next
Goes to the next screen.
Finish
Finishes creating the table and closes this dialog.
Cancel
Does not retain changes and closes this dialog.
Help
Displays the help document about this feature.
Data
Specifies the data source that you want to use to create the table. See the screen.
Available data resources
Lists all the business views in the current catalog. Specify the one you want to use.
Columns
Specifies the fields that you want to display in the table. See the screen.
Resources
Lists all the available data resources. You can also create dynamic formulas and aggregations to use in the table.
Adds the specified field to use in the table.
Removes the specified field that is not required in the table.
Moves the specified field one step up.
Moves the specified field one step down.
Column
Lists the fields that have been selected to display 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. - Custom Sort
Opens the Custom Sort dialog to set how groups will be sorted.
Select N
Opens the Select N dialog to specify the Select N condition.
Summary
Specifies to insert aggregations to the header/footer rows of the table and groups. See the screen.
Resources
Displays the aggregations selected in the Columns screen.
Summarized Fields
Displays the group fields selected in the Columns screen under the Table node.
Header
Represents the table header or the group header of a specific group. After an aggregation is selected in the Resources box, you can select the checkboxes in the column to insert the aggregation in the corresponding header rows.
Footer
Represents the table footer or the group footer of a specific group. After an aggregation is selected in the Resources box, you can select the checkboxes in the column to insert the aggregation in the corresponding footer rows.
Filter
Specifies to filter data displayed in the table. See the screen.
The options in the screen are the same as those in the Edit Filter dialog.
Style
Specifies the style of the table. See the screen.
Grow Report
Specifies the layout of the table.
- Vertically
Creates a vertical table.
Style
Specifies the style of the table.
Preview
Displays the selected layout and style effects.