Post reply

Enable/disable Parameter in SSRS 2005/2008

  • January 29, 2009 at 6:37 am

    #200734

    Hi,

    I am trying to enable and disable parameter in report base on value of another parameter.

    Like there is 3 parameter in report

    one parameter contain 2 values Free range date and Week

    2nd parameter is ToDate and 3rd parameter is FromDate.

    If I select Free range Date then 2nd and 3rd parameter will enabled and when I select week then

    ToDate should be enable and FromDate parameter should be disable

    Please give me reply if anyone know.

    Thanks,

    Umesh

  • January 30, 2009 at 10:48 am

    #935726

    Try setting your 2nd and 3rd parameters to allow nulls. That should let you process the report without requiring them to be filled in. However, your datasets that use those parameters are going to have to use an isnull function or some similar code to allow for the possibility that they are null. I have done this in a number of report definitions and it works fine.

  • February 3, 2009 at 5:02 am

    #937023

    thanks for reply.

    I used your solutions. But its showing me checkbox along with a Textbox which enabling/disabling textbox.

    I want only Textbox with calander control.

  • February 4, 2009 at 5:24 am

    #937837

    Yes this has been my requirement as well however once you declare a parameter to 'Allow NULL' in SSRS, the check-box gets added along side it while running the report.

  • February 18, 2009 at 6:29 am

    #945843

    Hi

    I am held up in a similar situation. Let me know if any one knows the answer

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

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