disable parameter

• sql_learner29

  SSCrazy Eights

  Points: 9107

  More actions

  January 19, 2010 at 12:22 pm

  #218303

  Hi all,

  I have a criteria to run my report with two different options:

  Run by Selecting Employee Name or Run by selecting Department

  No If I say Employee name it shows me a multivalue text box with all emp names...

  But if I select Department, it shows me again a multivalue textbox with all department names.

  Now the problem is in disabling the other box

  If I select Emp Name the Dept box should be diabled, and I should be allowed to Run my report only by selecting the Empname (same thing applies to Dept select)

  Both the prompts are MULTIVALUE so i cannot ALLOW NULL VALUE in them

  Any help

  Thanks in advance

  [font="Comic Sans MS"]
  ---------------------------------------------------

  Thanks [/font]

• Jack Corbett

  SSC Guru

  Points: 184394

  More actions

  January 20, 2010 at 7:21 am

  #1106032

  Duplicate post. Please post answers here.

  Jack Corbett
  Consultant - Straight Path Solutions
  Check out these links on how to get faster and more accurate answers:
  Forum Etiquette: How to post data/code on a forum to get the best help
  Need an Answer? Actually, No ... You Need a Question