For any geographic map in a report, you can further modify it at any time. This topic introduces how you can change the data displayed in a geographic map, and apply conditional formatting on the map markers to highlight important values.
This topic contains the following sections:
You can further modify a geographic map by accessing its shortcut menu wizard which contains a set of screens that are similar to the wizard screens used to create the geographic map. For example, you can change the data source the geographic map uses, edit the data displayed on the map, and so on.
To edit a geographic map using wizard
- Right-click the geographic map and select Geographic Map Wizard from the shortcut menu. Designer displays the Geographic Map Wizard dialog box.
- In the Data screen, you can specify a new data source for the geographic map.
- For a geographic map in a web report or library component, edit the data displayed on the map in the Display screen.
For a geographic map in a page report, edit the group settings, layout mode and marker properties in the Group, Layout, and Marker screens respectively.
- Select Finish to accept the changes.
For more information about defining a geographic map, refer to Inserting Geographic Maps in a Report.
Each value in a group of a geographic map is bound with a marker. You can add conditional formatting to markers of each group, so the markers that meet a specified condition can automatically apply the formatting you define for the condition. This is very useful to highlight the values that users may need to act on at runtime.
To apply conditional formatting to the markers in a geographic map
- Select the geographic map and then do one of the following:
- Navigate to Format > Conditional Formatting.
- Right-click the geographic map and select Conditional Formatting from the shortcut menu.
Designer displays the Conditional Formatting dialog box.
- Select a group level in the Geographic Map box.
- Select Add. Designer displays the Edit Conditions dialog box.
- Select Add Condition to add a condition line.
- From the field drop-down list, select the field on which the condition is based.
- Choose the operator with which to compose the condition expression from the operator drop-down list.
- From the value drop-down list, select the value of how to build the condition. You can also type the value manually.
You can specify an empty string as the value for a field of String type, by simply leaving the text box blank (value length=0). If you would like to filter space string (one or more spaces) and empty string, create a formula with the statement
Trim(@Field)which transforms the spaces into empty string, then use the formula to replace the field itself on which the condition is based.
- Repeat steps 4 to 7 to add more condition lines and define the logic relationship between the condition lines: "And", "Or", "And Not", or "Or Not".
To group some condition lines, select them and select Group, Designer then adds the selected condition lines in one group and applies them as one line of filter expression (you can also group conditions and groups together); to take out any condition or group from a group, select it and select Ungroup; to adjust the priority of the condition lines, select it and select Up or Down; to delete a condition line, select it and select Delete.
- Select OK to save the condition and close the dialog box.
Designer displays the newly added condition in the Condition box of the Conditional Formatting dialog box.
- In the Marker box, specify the settings you want to apply to the markers of the selected group level that meet the condition, including the image, the shadow image, and their width and height. If you want to change the width and height for the image/shadow image at the same time in a certain proportion, select Constrain Proportion.
- Repeat the preceding steps to add more conditions and define the marker settings for each condition.
To edit a condition, select the condition from the Condition box, select Edit, then edit the condition in the Edit Conditions dialog box.
To adjust the priority of the conditions, select a condition and select High or Low.
To delete a condition and the corresponding marker settings, select the condition from the Condition box and thenselect Remove.
- Select OK to save and apply the settings.
For a geographic map in a web report or library component, the conditional formatting settings higher priority than the settings defined for the Shape By, Color By, and Size By options in the map wizard.