Forum Discussion

BigLo's avatar
BigLo
Icon for Helper III rankHelper 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 'selectall' or to take all the values of this parameter if it isn't completed?

 

 

 

Need Help

2 Replies

  • V-lianl-msft's avatar
    V-lianl-msft
    Icon for Community Support rankCommunity 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
      Icon for Helper III rankHelper 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.