This SSRS article shows how to create a report parameter and perform a wildcard search to filter the table data with an example.
Right-Click on the Datasets folder to create a new DataSet. The screenshot below shows the data set we use for this Report Parameter wildcards example.
The Sql query that we used above SSRS example is:
SSRS Report Parameter Wildcard Search
Right-click on the Parameters folder and choose Add Parameter option to open the following window. Add Product as name and Enter product Name as prompt text.
Double-click on the CatDSet (primary dataset) and go to the Filters tab to add a filter. We have chosen Product Name as an expression and Like Operator. Next, click the ƒx button to add a parameter value combined with the * operator on both sides. Here, * acts as the wildcard.
=“*” & Parameters!Product.Value & “*”
Click Ok to close the Dataset Properties window.
And the final report of SSRS Parameter Wildcard Search is.
In the report preview, if we type Bike, it returns all the Product name which contains Bike at any position.
When I type Mountain, it returns all the rows whose product name contains Mountain.
To get the products that end with Bikes, change the expression as below and type Bikes
=“*” & Parameters!Product.Value
Products Start with Bikes
=Parameters!Product.Value & “*”
If you want to do it at the query level, you can concat the parameter value with the % symbol on both sides. So, create a new report with the below code and design table to see the preview.
