I am in the midst of creating some reports for our new SQL RS server and am wondering if it is possible to hide some parameters (ie not have them there to be used) dependant on the selection of previous parameters?

a staff directory might have a parameter for division and one for office location. If a certain division is selected then the office parameter refreshes to show only offices where that division has employees. This is fine. When the division parameter is selected to show all divisions, is it possible to have the office parameter disabled or hidden as this is then irrelevant, the user wants to see all staff?

i am guessing the solution to this would be something like vbscript in the actual rdl file?