topic Parameter SelectAll Values of a parameter in Developer

Parameter SelectAll Values of a parameter

BigLo — Tue, 22 Jun 2021 14:04:29 GMT

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 'selectall' or to take all the values of this parameter if it isn't completed?

Re: Parameter SelectAll Values of a parameter

V-lianl-msft — Thu, 24 Jun 2021 05:30:51 GMT

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.

Re: Parameter SelectAll Values of a parameter

BigLo — Mon, 28 Jun 2021 07:28:13 GMT

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.