Optional Report parameters

[jbluhm]

I am trying to design a paginated report with optional parameters (i.e they can proceed with the report with no selections in the parameters or they can select multiple different parameters). Am I right to start in the parameters within the dataset properties with the following script: =IIF(IsNothing(Parameters!ClientsClientName.Value), ? I know the false would be Parameters!ClientsClientName.Value so what would the true value be to select everything pertaining to that field by default? 

Or would I start in the default values on the report parameter properties?

[v-yetao1-msft]

Hi @jbluhm 

You can refer to the link below . Here are some of the most common ways to use parameters.

https://docs.microsoft.com/en-us/sql/reporting-services/report-design/report-parameters-report-build...

Best Regards

Community Support Team _ Ailsa Tao

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