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 7-20 shows an example of a completed map rule, which replaces the value A with the value Excellent.

Figure 7-20  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 7-21.

Figure 7-21  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 7-22 shows an example of three map rules created for the selected data element.

Figure 7-22  Three map rules for an element

5	Preview the report to check the results of the map rules.