How to create a simple string filter in SSRS

If you are sure you’ve typed your filter condition correctly, to either include or exclude data based on a string match, try this.

In the “expression” field (where you specify where to look for a condition), use the trim() command. It works like this. If your field is “foobar”, you’d enter =trim(foobar.value) in the expression area. This is because your field may have extra spaces that you don’t see, and won’t know about until your filter won’t work.

I’ve included an example, where my condition field is “Group” and I want to exclude records that match the string “Room”. Note, there are no quotes around the field in the filter window. The string datatype is assumed.

Yes, I’ve been building reports in SQL Server lately. :)

SQL Server Reporting Studio table properties