Shape Map Data Binding Wizard Dialog Box
You can use the Shape Map Data Binding Wizard dialog box to bind a dataset to a shape map and display values on the shape map areas. This topic describes the options in the dialog box.
Designer displays the Shape Map Data Binding Wizard dialog box when you navigate to Menu > Insert > Bind Data, or select Bind Data on the toolbar in the Shape Map Editor dialog box.
The dialog box contains the following screens:
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 your work 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 to bind with the shape map.
Data resource box
This box lists the predefined data resources in the current catalog. Select one and Designer automatically creates a dataset based on it for the shape map.
More Options/Less Options
Select to show or hide the options for specifying a dataset for the shape map.
- New Dataset
Select to create a dataset based on a data resource in the current catalog. If 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. You can also select the first item under a resource node to add or create a data resource of the type in the catalog and use it to create the dataset. - Existing Dataset
Select to use a dataset from the ones that you have created in the current page report. You can select Edit to modify 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
Select to inherit the dataset from the parent object.
Group Screen
Use this screen to specify the criteria for grouping data in the dataset.
Resources
This box lists the data fields in and related to the specified query resource, which you can use to group data of the dataset.
Add button
Select to add the specified field in the Resources box as a group-by field to group data of the dataset. You can add only one group for the dataset.
Remove button
Select to remove the specified group-by field.
Group By
This column shows the group-by field on which you select to group data of the dataset.
Sort
Specify how you want to sort the groups. You can select from the following options:
- Ascend
Select to sort the groups in an ascending order (A, B, C). - Descend
Select to sort the groups in a descending order (C, B, A). - No Sort
Select to sort the groups 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.
Special Function
Select the special function for the group-by field if it is of the Numeric, String, Date, or Time data type. Select a special function from the drop-down list to specify to which level to group the data, or select Customize to set the function in the Customized Function dialog box.
Custom Sort
Designer enables this button after you have selected Custom Sort from the Sort column to define the sort manner of the groups. Select it to specify how to sort the groups.
Special Group
Designer enables this 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 groups.
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 to calculate data based on the group that you add for the dataset.
Resources
This box lists the data fields in and related to the specified query resource, which you can use to create summaries for the group.
Add button
Select to add the specified field in the Resources box based on which to create a summary.
Remove button
Select to remove the specified summary.
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
This column shows the fields that you add to create summaries for the group.
Aggregate Function
This column shows the aggregate functions that you select to use for the summaries.
Distinct On
Designer enables this option and you should set it when you select DistinctSum as the aggregate function. Select the ellipsis to select the fields according to whose unique values to calculate DistinctSum in the Select Fields dialog box.
Break Field
This column shows the name of the group-by field that you add in the Group screen. Designer calculates the summaries based on this group.
Filter
Use this screen to narrow down the data to display on the map areas.
Designer displays the same options in the Filter screen as in the Edit Filter dialog box.