Skip to Content

We can filter report results based on Text search strings.

  1. Create a new input control that sets a variable to whatever the user types.
  2. Create a second variable that searches the dimension we want to filter on for the string contained in the first input control variable
    • The variable will output 1 if the search string is found, 0 otherwise
    • The variable should force the search string and the dimension we are searching to be all upper or lowercase
    • The variable should check the POS function for a non-null value to determine if the search string exists.
  3. We can search 1 or more fields by duplicating the search condition for each dimension to search
  4. Insert the variable as a column in the tables you want to search and mark it as hidden (optional), and apply a filter based on the variable to the table or report.

Example:

=If Pos(Upper([ValueToSearch]); Upper([SearchString])) > 0 Then 1 Else 0

To report this post you need to login first.

1 Comment

You must be Logged on to comment or reply to a post.

Leave a Reply