Post reply

How to hide/view a SSRS report parameter control dynamically at runtime?

  • March 6, 2014 at 2:34 am

    #286538

    Hi,

    I am using SSRS 2005. I want to enable/disable or hide/view parameters based on another parameter selection.

    Say Suppose I have 5 parameters. User selects first value in first parameter I should show only Second parameter and hide remaining 3 parameters (Parameter 3,Parameter 4 & Parameter 5).

    If user selects second value in first parameter I should show third parameter and hide remaining 3 parameters(Parameter 2,Parameter 4 & Parameter 5).

    Similarly If user selects third value in first parameter I should show fourth and fifth parameter and hide remaining 2 parameters(Parameter 2 & Parameter 3).

    There is no relationship between these parameters except user selection.

    I can not see any Visible property for report parameters.

    Any "builtin" support in SSRS for this scenario.

    Appreciate your help.

    Regards,

    Bala

  • March 6, 2014 at 2:42 am

    #1694575

    I don't think this is supported out of the box in SSRS.

    Are you using Report Manager or SharePoint to view the reports?

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 6, 2014 at 4:56 am

    #1694634

    Thanks for Reply.

    RDL is deployed in Report sever and the Report is integrated with .net application. End user view the Reports from Application.

    Regards,

    Bala

  • March 6, 2014 at 4:58 am

    #1694637

    In that case I would write my own parameter selection boxes and call the report using an URL with the parameters supplied.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • March 6, 2014 at 5:24 am

    #1694653

    Thanks for the tips.

    So I want to create an independent web page in .net that has the entire parameters section and then a submit button that calls the report with the selected parameters.

    From SSRS side, I want to hide the parameters statically and make default values as NULL.

    Can I achieve Show/Hide parameter functionality by this way?

    Regards,

    Bala

  • March 6, 2014 at 5:29 am

    #1694654

    That should be possible yes:

    Hiding parameter area when viewing reports

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply