Post reply

Boolean Parameter in SSRS 2008

  • March 23, 2010 at 12:02 am

    #216903

    Hi All,

    I am using SSRS 2008 and I have boolean parameter "Yes" or "No", If use select Yes option, then two textbox should be enabled and they can enter the values they want, If he/she selects No option then Dropdownlist should be enable. Please can any on suggest me on the same.

    I have tried on Textbox property expression like

    =IIF(Parameters!DateRange.Value=Yes,Yes,False) and even tried

    =IIF(Parameters!DateRange.Value=1,1,0). Nothing is working out.

    Please suggest me

    Thanks,

    Nanda

  • March 23, 2010 at 12:29 am

    #1137989

    Hi,

    U mean based on user options u need to hide and show the parameters in the Report?

    Thanks,

    Veeren

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • March 23, 2010 at 12:31 am

    #1137990

    Yes I want the same

  • March 23, 2010 at 12:38 am

    #1137996

    I think we can't able show/hide the report parameters based on Expressions.

    Thanks

    Veeren:)

    Thanks & Regards,
    Veeren.
    Ignore this if you feel i am Wrong. 😉

  • March 23, 2010 at 3:44 am

    #1138048

    veeren4urs (3/23/2010)

    I think we can't able show/hide the report parameters based on Expressions.

    Thanks

    Veeren:)

    This is correct. The best alternative is to use cascading parameters. This means that the values of other parameters depend on another parameter. so you could have parameter 1 with yes and no. And parameter 2 and 3 that get a value with N/A when they're not available or normal values when they are.

    To create a cascading parameter simply add a filter to the dataset of the parameter(2 and 3) values based on the selected value of parameter 1.

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

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