I am using a SharePoint list as my data source for an SSRS report. I have a multi-choice column named "Office". When a task applies to an office we check the box. Most of the time a task applies to more than one office. I need a way to create a parameter that allows people to select their office and only show the rows in the report that apply to them.
SSRS returns the multi-choice column as a string that looks something like: OfficeA#;OfficeB#;OfficeC#;
When I tried creating a parameter with available values OfficeA, OfficeB, OfficeC, etc and then tried to create a filter that IF Fields!Office.Value is in Parameters!Office.Value that it returns those rows, it returns nothing because the actual value is something like OfficeA#;OfficeC#; and not a single value.
I'd really appreciate help with this.