Create Banded Object wizard

This wizard appears when you click Insert > Banded Object on the menu bar, or click the Insert Banded Object button on the Insert toolbar. It helps you to insert a banded object into a report, and consists of the following screens:

Back

Goes back to the previous screen.

Next

Goes to the next screen.

Finish

Finishes creating the banded object and closes this dialog.

Cancel

Does not retain changes and closes this dialog.

Help

Displays this help document.

Data screen

Specifies the dataset that you want to use to create the banded report. See the screen.

Define a dataset for the object

Specifies the dataset on which the banded object will be built.

Display screen

Specifies the data fields that you want to display in the banded object. See the screen.

Resources

Lists all the available data resources.

Adds the specified field to use in the banded object.

Removes the specified field that is not required in the banded object.

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

Display Name

Shows the display names of the selected fields. You can double-click 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 banded object.

Group screen

Specifies the data fields that are used 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 banded object.

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

Sort

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

Special Function

If the group by field is of Numeric/String/Date/Time type, you can select a special function for the field in the Special Function column to further specify to which level the data will be grouped by.

If Customize is selected, the Customized Function dialog will be displayed, in which you can set the function by your own.

Sort Group By

Specifies how to sort the groups. Activated only when you have clicked Sort Group By 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.

Summary screen

Specifies the fields on which you want to create aggregate functions. See the screen.

Resources

Lists all the available data resources.

Adds the selected field as the summary field to the banded object.

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

Aggregate Function

Specifies the function to summarize the selected field.

Break Field

Displays a defined field on which the summary will be calculated. If a summary field is added below the Banded Object node, the break field is null and the summary will be calculated on the whole dataset.

Filter screen

Specifies to filter data displayed in the banded object. See the screen.

For details about options in the screen, see Edit Filter dialog.

Style screen

Specifies the style of the banded object. See the screen.

Grow Report

Specifies the layout of the banded object.

Style

Specifies the style of the banded object.

Preview

Displays the selected layout and style effects.

Inherit Style

Specifies whether to make the banded object take the style of its parent. Available only when the banded object is to be inserted into another banded object.

Related topics: