parameter Disabling

Last post 07-08-2009 9:02 AM by satya. 1 replies.
Page 1 of 1 (2 items)
Active Topics My Discussions Unanswered Sort Posts: Previous Next
  • 06-30-2009 11:08 PM

    parameter Disabling

    HI

     i am having problem in parameter disableing in ssrs. in my report i am havinfg 4 paramters  based on the first paramter value i wnat to to disable 2nd,3rd,4th paramaeter values please send solution

    its urgent

    Thanks & Regards

    Subhash

     

     

     

  • 07-08-2009 9:02 AM In reply to

    • satya
    • Top 10 Contributor
    • Joined on 11-05-2002
    • United Kingdom
    • Posts 23,751
    • Microsoft MVP
      Moderator

    Re: parameter Disabling

    Within SSRS it's not available as a specific feature, but possibly a work around that gives the appearance of disabled is to set them to Null (or Nothing in the expression).

    You have to set the parameter to "Allow Nulls".  With this done a parameter has a check box next to it on the report screen. When you put a tick in the checkbox, the textbox for the parameter itself becomes disabled.

     

    -Satya S K J

    SQL Server MVP



    Knowledge is Power, you will gain by sharing it. SSQA.net - Invisible contributions to the users & visible success in SQL Community.
Page 1 of 1 (2 items)
Active Topics   My Discussions    Unanswered Posts


© 2010 Jude O'Kelly All Rights Reserved.