How to make filter/parameters independent in report?

[anmolmalviya05]

Hello Everyone, I need some help/guidance in below scenario:

I have created a paginated report using SSRS, and i have created 2 parameters in it named Client and Suffix.

When I run the report it ask me to select values in parameter. I want that parameters should be independent, i.e.  if i select values in any one parameter and keep the other one empty, the report will get run. when I'm trying this it says please select a value in other parameter too

[Anonymous · Accepted solution]

Hi @anmolmalviya05 ,

We can define the parameters in Report Builder, allow NULL values for Suffix, and also give them some specific values, I hope these measures will be helpful to you!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[anmolmalviya05 · Accepted solution]

Hi @Anonymous , I have a list of 50-60 clients and suffix, And I want to provide multi select option, while selecting it, it's throwing error that we can't select multiple value and null value at a time 

[Anonymous · Accepted solution]

Hi @anmolmalviya05 ,

We can define the parameters in Report Builder, allow NULL values for Suffix, and also give them some specific values, I hope these measures will be helpful to you!

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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

[anmolmalviya05 · Accepted solution]

Hi @Anonymous , I have a list of 50-60 clients and suffix, And I want to provide multi select option, while selecting it, it's throwing error that we can't select multiple value and null value at a time 

[Anonymous · Accepted solution]

Hi @anmolmalviya05 ,

Unfortunately, due to product limitations, the NULL option is mutually exclusive with Multiple, and we can only choose one of them, not both.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

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