Parameter SelectAll Values of a parameter

[BigLo]

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?

[V-lianl-msft · Accepted solution]

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-paramete... 

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]

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.