Forum Discussion

BigLo's avatar
BigLo
Helper III
5 years ago
Solved

Parameter SelectAll Values of a parameter

Hi,   I'm using the API to generate paginated reports. I've parameters of type Integer in my report builder. I am forced to give (at least) one value to my parameters. Is it possible to make a '...
Need Help
V-lianl-msft's avatar
V-lianl-msft
Community Support
5 years ago

Hi BigLo ,

 

For the URL string passed from calling the report, if the user has actually selected a value from the slicer, only parameters are referenced. If the user does not select any value from any slice, only the default paging report URL string needs to be submitted.

Please refer to this blog:

https://www.mssqltips.com/sqlservertip/3506/set-select-all-as-default-for-multivalue-report-parameters-in-sql-server-reporting-services/ 

 

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

BigLo's avatar
BigLo
Helper III
5 years ago

Thanks a lot, setting the full list as the default works fine.

 

Is it possible to display the value of the user's selection in a textbox? If I have only one value, no problem but if the user selects 'select all', I don't know how to do.