Show Values

The Show Values feature provides a list of values derived from the content of the Results or Table section. Because Show Values retrieve every unique value available, it is best not to use this feature when the data item is large, consists mostly of unique values, or does not change frequently (for example, telephone numbers). In this situation, custom values are recommended when you want to avoid extra calls to the database.

The value list that initially displays was saved with the imported Interactive Reporting document file, and it is not the latest value list from the database.

To show the latest value list, select View, then Refresh.

  To specify a database filter value:

  1. Select the Show Values tab.

  2. Select Include Nulls to allow nulls to pass the filter and display in the data set.

  3. Expand the Operator drop down and select a comparison operator for the filter expression.

    Check Not to reverse an operator condition.

    For example, if you specify the > Greater Than and then specify a value of 10,000, then values greater than 10,000 are returned. Values which pass the comparison test are included. Valid operators include:

    Table 35. List of Comparison Operators 

    Operator

    Retrieves Records Where the Filtered Item:

    Equal (=)

    Equals the specified value(s).

    Not Equal (<>)

    Does not equal the specified value(s).

    Less Than (<)

    Less than the specified value(s).

    Less or Equal (<=)

    Equal to or less than the specified value(s)

    Greater Than (>);

    Is greater than the specified value(s).

    Greater or Equal (>=);

    Is equal to or greater than the specified value(s)

    Begins With

    Begins with the specified value(s) up to and including the end value.

    Contains

    Contains the specified value(s) regardless of location.

    Ends With

    Ends with the specified value(s).

    Like (with wildcards)

    Retrieves records where a text string is displayed and reflects the placement of the specified value(s).

    For example, a Name Like %ZE_ retrieves records for all employees whose names have the letters Ze followed by a single character at the end

    Is Null

    Has no value; for example a field in which no data has been entered.

    Between

    Retrieves records where the value of the filtered item lies between (and does not equal) the specified values.

    Not (with operator)

    Negates the operator it precedes, reversing the results of the equation

  4. Highlight the values to include as filters from the Values list.

    To select an individual value, highlight it in the Values pane.

    To select multiple and contiguous values in the Values pane, hold the [Shift] and scroll down to or up to the items.

    To select multiple, but non-contiguous values in the Values pane, hold the [Ctrl] key and highlight the items.

  5. Click Set.

    To suspend a filter temporarily without deleting it, click Ignore.