SQL Server Performance

parameter Disabling

Discussion in 'SQL Server 2008 Analysis Services' started by subhash6008, Jun 30, 2009.

  1. subhash6008 New Member

    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
  2. satya Moderator

    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.

Share This Page