Browse or Search the Values 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 New South Wales. The actual value in the database for New South Wales is NSW, and this is what you must insert in the filter expression to obtain the correct results.

Procedure

  1. In the source, data items, or query tab, select the data item you want to browse and in properties click Expression.
  2. If you want to insert a single value, click Select Value select single value icon.
  3. If you want to insert multiple values, click Select Multiple Values select multiple values icon.
  4. In the Values box, click the value you want to insert in the expression.
    Tip: Use the Keywords box to search for specific values. If you select Use Tab as keyword delimiter, you can add a tab in the Keywords box only by copying and pasting a tab (or the string you want to search on with a tab in it), from another application, such as Notepad. 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 right arrow icon 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 copy selected single values icon 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.