Modifying Geographic Maps
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 formats 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.
- 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 formats to the markers, then when a specified condition is fulfilled, Logi Report applies the format bound with the condition to the markers automatically. This is very useful to highlight the values that the report users may need to act on.
To add conditional formats to the markers in a geographic map:
- Select the geographic map and then do one of the following:
- Select Format > the Conditional Formatting button .
- 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 the Add button . Designer displays the Edit Conditions dialog box.
- Select the Add Condition button 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) as well as 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 the Group button, 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 the Up or Down button; to delete a condition line, select it and select the Delete button.
- 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 which you want to apply to the marker of the selected group level when the condition is fulfilled, 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 above steps to add more conditions and define the marker properties for each condition.
To edit a condition, select the condition from the Condition box, select the Edit button , then edit the condition in the Edit Conditions dialog box.
To adjust the priority of the conditions, select a condition and select the High or Low button.
To delete a condition and the corresponding marker properties, select the condition from the Condition box and then select the Remove button .
- Select OK to save and apply the settings.
For a geographic map in a web report or library component, the conditional format settings have higher priority than the settings defined for the Shape By, Color By, and Size By options in the map wizard.