How to map data values to different display values
1 Select the data element for which to replace values.
2 In Property Editor, choose the Map tab.
3 In Map List, choose Add to create a map rule.
4 In New Map Rule, specify the following information:
1 In the first field, specify the expression that refers to the data set field for which you want to replace values. You can select, from the drop‑down list, Value of this data item. The following is an example of an expression:
row["creditrank"]
2 In the second field, select an operator from the list. For example:
Equal to
3 In the third field, specify the value to replace. For example:
"A"
You must enclose string values in quotation marks (" ").
4 Specify the value that you want to display, using one of the following options:
Under “Then display following value:”, type the text to display. For example:
Excellent
Specify a resource key. Choose Browse to select a resource key. You can access resource keys only if you have assigned a resource file to the report.
Figure 8‑55 shows an example of a completed map rule, which replaces the value A with the value Excellent.
Figure 8‑55 A map rule
5 Choose OK. The rule that you created appears in Map List. When you select the rule, the display value appears in the box at the right, as shown in
Figure 8‑56.
Figure 8‑56 Map rule and its display value in Property Editor
6 Repeat steps
3 through
5 to create additional rules, one for each data value to replace.
Figure 8‑57 shows an example of three map rules created for the selected data element.
Figure 8‑57 Three map rules for an element
5 Preview the report to check the results of the map rules.
