Previous Topic
Create Banded Object Dialog Box
You can use the Create Banded Object dialog box to create a banded object in a report. This topic describes the options in the dialog box.
Designer displays the Create Banded Object dialog box when you select Insert > Banded Object, and provides you with different options in the dialog box according to the type of the data resource used for the banded object: business view or query resource.
Create Banded Object Dialog Box - Business View Based
When you use the Create Banded Object dialog box for creating a banded object using a business view, you see the following screens in the dialog box:
You see these buttons in all the screens:
Back
Select to go back to the previous screen.
Next
Select to go to the next screen.
Finish
Select to finish creating the banded object and close the dialog box.
Cancel
Select to close the dialog box without saving any changes.
Help
Select to view information about the dialog box.
Data Screen
Use this screen to specify the business view using which to create the banded object. You can select from all the predefined business views in the current catalog.
Inherit from the Parent
Designer displays the option only when you have specified to insert the banded object into any of the following panels in a banded object: banded header panel, banded footer panel, group header panel, or group footer panel. Select it if you want the banded object to inherit the business view that its parent banded object uses.
Display Screen
Use this screen to specify the detail fields to display in the banded object.
Resources
The box lists the resources in and related to the specified business view, which you can use as detail fields in the banded object.
Add button
Select to add the specified field in the Resources box to the banded object.
Remove button
Select to remove the specified field from the banded object.
Move Up button
Select to move the specified field higher in the display order.
Move Down button
Select to move the specified field lower in the display order.
Display Fields
The column shows the detail fields that you add to display in the banded object.
Display Name
The column shows the labels of the detail fields in the banded object, which by default are the display names of the added fields. You can select in the text boxes to edit the labels, or select the Auto Map Field Name checkboxes in the text boxes to automatically map the labels to the dynamic display names of the fields at runtime.
Sort Fields By
Select to open the Sort Fields By dialog box to specify how to sort the detail data in the banded object.
Group Screen
Use this screen to specify the criteria for grouping data in the banded object.
Resources
The box lists the resources in and related to the specified business view, which you can use as group-by fields in the banded object.
Add button
Select to add the specified field in the Resources box as a group-by field in the banded object.
Remove button
Select to remove the specified group-by field from the banded object.
Move Up button
Select to move the specified group to a higher group level.
Move Down button
Select to move the specified group to a lower group level.
Group By
The column shows the group-by fields on which you select to group data in the banded object.
Sort
The column shows how you want to sort groups at each group level. You can select from the following options:
- Ascend
Select to sort groups at the specified group level in an ascending order (A, B, C). - Descend
Select to sort groups at the specified group level in a descending order (C, B, A). - No Sort
Select to sort groups at the specified group level in their original order in database. - Custom Sort
Select to open the Custom Sort dialog box to set how to sort the groups at the specified group level.
Select N
Select to open the Select N dialog box to specify the Select N condition for the specified group level.
Summary Screen
Use this screen to specify the summaries to calculate data in the banded object.
Resources
The box lists the resources in and related to the specified business view, which you can use to calculate data in the banded object.
Add button
Select to add the specified field in the Resources box to calculate data in the banded object.
Remove button
Select to remove the specified summary from the banded object.
Move Up button
Select to move the specified summary higher in the display order.
Move Down button
Select to move the specified summary lower in the display order.
Summarized Fields
The column shows the fields that you add to calculate data in the banded object.
Position
The column shows the position of the summaries. Designer places the summary added for a group level in the group's footer panel; if you add a summary for the Banded Object level, Designer places it in the banded footer panel.
Column
The column shows where to place the summaries. By default, Designer places the summaries and their name labels in the first two detail columns.
Filter Screen
Use this screen to narrow down the data to display in the banded object.
Designer displays the same options in the Filter screen as in the Edit Filter dialog box.
Style Screen
Use this screen to specify the style of the banded object.
Grow Report
The box displays in which layout to create the banded object, which can only be Vertically.
Style
The box lists the styles that you can apply to the banded object. Select the style for the banded object.
Preview
The box displays a diagram illustrating the effect of the selected style on the banded object.
Inherit Style
Designer displays the option and selects it by default if you have specified to insert the banded object into another banded object. Clear it if you do not want the banded object to inherit the style of its parent.
Create Banded Object Dialog Box - Query Based
When you use the Create Banded Object dialog box for creating a banded object using a query resource, you see the following screens in the dialog box:
You see these buttons in all the screens:
Back
Select to go back to the previous screen.
Next
Select to go to the next screen.
Finish
Select to finish creating the banded object and close the dialog box.
Cancel
Select to close the dialog box without saving any changes.
Help
Select to view information about the dialog box.
Data Screen
Use this screen to specify the dataset for the banded object.
Data resource box
The box lists the predefined data resources in the current catalog. Select one and Designer automatically creates a dataset based on it for the banded object.
More Options/Less Options
Select to show or hide the options for specifying a dataset for the banded object.
- New Dataset
Select to create a dataset based on the current catalog data resources. When you select a query, Designer enables the Edit button at the bottom and you can select the button to edit the query in the Query Editor dialog box. - Existing Dataset
Select to use a dataset from the ones that you have created in the current page report. You can select the Edit button to edit the specified dataset in the Dataset Editor dialog box, or select <New Dataset...> to create a dataset in the page report using the New Dataset dialog box.
- Current Dataset
Designer enables this option when the parent object where you have specified to insert the banded object already applies a dataset. Select it if you want the banded object to inherit the dataset from its parent.
Display Screen
Use this screen to specify the detail fields to display in the banded object.
Resources
The box lists the data fields in and related to the specified query resource, which you can use as detail fields in the banded object.
Add button
Select to add the specified field in the Resources box to the banded object.
Remove button
Select to remove the specified field from the banded object.
Move Up button
Select to move the specified field higher in the display order.
Move Down button
Select to move the specified field lower in the display order.
Display Fields
The column shows the detail fields that you add to display in the banded object.
Display Name
The column shows the labels of the detail fields in the banded object, which by default are the display names of the added fields. You can select in the text boxes to edit the labels.
Sort Fields By
Select to open the Sort Fields By dialog box to specify how to sort the detail data in the banded object.
Group Screen
Use this screen to specify the criteria for grouping data in the banded object.
Resources
The box lists the data fields in and related to the specified query resource, which you can use as group-by fields in the banded object.
Add button
Select to add the specified field in the Resources box as a group-by field in the banded object.
Remove button
Select to remove the specified group-by field from the banded object.
Move Up button
Select to move the specified group to a higher group level.
Move Down button
Select to move the specified group to a lower group level.
Group By
The column shows the group-by fields on which you select to group data in the banded object.
Sort
The column shows how you want to sort groups at each group level. You can select from the following options:
- Ascend
Select to sort groups at the specified group level in an ascending order (A, B, C). - Descend
Select to sort groups at the specified group level in a descending order (C, B, A). - No Sort
Select to sort groups at the specified group level in their original order in database. - Special Group
Select to open the User Defined Group dialog box to define grouping information. - Custom Sort
Select to open the Custom Sort dialog box to set how to sort the groups at the specified group level.
Special Function
The column shows the special functions that you select for the group-by fields of the Numeric, String, Date, and Time data types. Select a special function from the drop-down list to specify to which level to group the data of the specified field, or select Customize to set the function in the Customized Function dialog box.
Custom Sort
Designer enables the button after you have selected Custom Sort from the Sort column to define the sort manner of groups for the specified group level. Select it to specify how to sort the groups.
Special Group
Designer enables the button after you have selected Special Group from the Sort column to define a special group. Select it to specify how to group your information.
Select N
Select to open the Select N dialog box to specify the Select N condition for the specified group level.
Group Filter
Select to open the Group Filter dialog box to specify the group filter condition.
Summary Screen
Use this screen to specify the fields on which to create summaries in the banded object.
Resources
The box lists the data fields in and related to the specified query resource, which you can use to create summaries in the banded object.
Add button
Select to add the specified field in the Resources box based on which to create a summary in the banded object.
Remove button
Select to remove the specified summary from the banded object.
Move Up button
Select to move the specified summary higher in the display order.
Move Down button
Select to move the specified summary lower in the display order.
Summarized Fields
The column shows the fields that you add to create summaries in the banded object.
Aggregate Function
The column shows the aggregate functions that you select to use for the summaries.
Distinct On
Designer enables the option and you should set it when you select DistinctSum as the aggregate function. Select the ellipsis button 
to select the fields according to whose unique values to calculate DistinctSum in the Select Fields dialog box.
Break Field
The column shows the groups on which to calculate the summaries. If you add a summary for the Banded Object level, the break field is null and Designer calculates the summary based on the whole dataset.
Position
You can use the option together with the Column option to specify the location where to place a summary.
- Header
Select it to place the summary in the header panel. If you add the summary for a specific group, Designer places it in the group's header panel; if you add the summary for the Banded Object level, Designer places it in the banded header panel. - Footer
Select it to place the summary in the footer panel. If you add the summary for a specific group, Designer places it in the group's footer panel; if you add the summary for the Banded Object level, Designer places it in the banded footer panel.
Column
You can use the option together with the Position option to specify the location where to place a summary.
- Detail
Select it to place the summary and its name label in the first two detail columns. - Summary
Select it to place the summary in a separate summary column.
Filter Screen
Use this screen to narrow down the data to display in the banded object.
Designer displays the same options in the Filter screen as in the Edit Filter dialog box.
Style Screen
Use this screen to specify the style of the banded object.
Grow Report
The box lists the layouts in which you can create the banded object.
- Vertically
Select to create a vertical banded object. - Horizontally
Select to create a horizontal banded object. - Mailing Label Format
Select to create a cross banded object in the form of a mailing label layout.
Style
The box lists the styles that you can apply to the banded object. Select the style for the banded object.
Preview
The box displays a diagram illustrating the effect of the selected style on the banded object.
Inherit Style
Designer displays the option and selects it by default if you have specified to insert the banded object into another banded object. Clear it if you do not want the banded object to inherit the style of its parent.