RD BI360 How-to: Use Wildcards in Parameters with the Like Operator

Summary:

This article gives step-by-step instructions for how to adjust parameters to use wildcards at runtime. This is a useful technique to filter data to, for example, find certain accounts in AccountString. 

Note: Underscores are not currently supported.

Article Sections:

• Method
  • Parameter
  • Setup in Report Parameter Wizard
• Properties

Method:

Below demonstrates how to use the filter given a wildcard:

Parameter

1. Create a report with a Measure and a Dimension. Create a new selection group on the Row.
2. Go to the row in Layout Editor to view the dimension.
3. Change the operator to Like.

Setup in Report Parameter Wizard

Below is the process to use the Like command:

1. Click Report Parameters in the OneStop Reporting or Solver Reporting ribbon and click the Edit Parameters button.
2. Change the Prompt to instruct the users on what to do.
3. Run the report with a B and see that it doesn’t return results.
4. Type in Like command % after the B and it will return all records that start with a B.
5. Wrap the B with Like command % and all records containing a B will return.

Properties:

Applies to:

Report Designer

BI360