Post reply

cascading parameter

  • April 25, 2012 at 9:07 pm

    #260411

    hi,

    i need to have cascading parameter ,

    there is 1 boolean parameter,if i click on true,the other parameter's drop- down should enable.If i choose false

    it will be disable.

    How to do that?

  • April 27, 2012 at 8:09 am

    #1480451

    so the available values for the second parameter need to be as a result of a stored procedure that uses the first as a parameter.

    For instance, Add a dataset to your report that does something along the lines of this:

    If @YesNo = Yes

    SELECT 1,2,3,4

    IF @YesNo = No

    SELECT 0

    make a parameter called YesNo in SSRS, and manually add two specified values, with labels Yes and No, and corresponding values of 1 and 0.

    Now make another parameter called "List" or something and in the available values section of the properties, click "Get values from a query" and select your dataset you just added. You can enter the first parameter (YesNo) as the required parameter for this parameter.

Viewing 2 posts - 1 through 1 (of 1 total)

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