Browse the Data of a Data Item

When building expressions in the expression editor, you can browse the data of a data item. This is useful when you do not know how a particular value is stored in the database. For example, you want to filter a report so that it shows data for only China. The actual value in the database for China is The People’s Republic of China, and this is what you must insert in the filter expression to obtain the correct results.

Steps

1. In the source, data items, or query tab, right-click the data item you want to browse.

2. If you want to insert a single value, click Select Value.

3. If you want to insert multiple values, click Select Multiple Values .

4. In the Values box, click the value you want to insert in the expression.

   Tip: Use the Words box to search for specific values. If the data source is case sensitive and you want to perform a case insensitive search, click the Search arrow and then click Case Insensitive.

5. If you clicked multiple values, click the right arrow button  to add them to the Selected values box.

6. Click Insert.

   Tip: To control where values appear in the Expression Definition box, you can click the copy button if you selected a single value  or the copy all button if you selected multiple values instead. The values are copied to the clipboard, and you can then paste them where you want.