topic Filter a SSRS Dataset based on a parameter value in Report Server

Filter a SSRS Dataset based on a parameter value

Anonymous — Fri, 19 Apr 2024 13:03:39 GMT

Is it possible to apply a filter on a col based on the parameter value passed?

or e.g if Parameter.value = Yes then filter ColumnA like '%United Kingdom"

else no filter

I know I can easily write this using a Stored Proc but I am using Power Bi Paginated reports pointing to a PBI Data model.

If there is an alternate approach then happy to try that too.

Anonymous — Tue, 23 Apr 2024 01:51:22 GMT

Hi Anonymous ,

Below is my table:

The following expression might work for you:

IIf(Parameters!ReportParameter1.Value = "Yes" And Fields!Name.Value = "%United Kingdom", Fields!Name.Value , "")

The final output is shown in the following figure:

Best Regards,

Xianda Tang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.