How do I make wildcards work in a like operator in SQL Server reporting services?

reporting-services ssrs-2008 reportbuilder
David Silva Smith picture David Silva Smith · Feb 4, 2011 · Viewed 51.8k times · Source

I have added a filter expression using the like operator. What do I put in the value field? my parameter is named @test and I'd like the filter to function as a like %@test% would in SQL. I want it to act like %@test% so I can pass '' to get all values for the query.

Answer

David Silva Smith picture David Silva Smith · Feb 4, 2011

I got this to work by adding a filter expression with a like operator and setting the value to this:

="*" + Parameters!Roles.Value + "*"

To get all values I pass ''.

Related questions

LookupSet based on two fields combined instead of one

I have two datasets: Dataset1 (primary) and Dataset2. My report dataset is Dataset1. I want to access Gross premium Amount from Dataset2 and put it in the report. The report is working just fine if the parameter for "market name" …

Read More
How do I format date and time on ssrs report?

on SSRS report I need to show todays date and current time i tried this =FormatDateTime(Now,"MM/dd/yyyy hh:mm tt") but this is not working for me giving an error. Anyone please help me for expression ? I …

Read More
How to get rid of blank pages in PDF exported from SSRS

I have a two-page SSRS report. When I exported it to PDF it was taking 4 pages due to its width, where the 2nd and 4th pages were displaying one of my fields from the table. I tried to set the …

Read More