Reporting Services how do I disable a drop down box

Hi,

SQL Server Reporting Services 2005.

I have a tick box that is required to enable or disable two associated drop down boxes.

Example: Tick box has 2 associated drop down boxes. The drop down boxes list details of Area from a database. The Area is linked to Properties. This allows the selection of Properties to be filtering by Area. Ticking the tick box allows the user to select from the drop down boxes.

I have tried setting the Report Parameters in different ways, but without any success.

Please can someone suggest how I can set the two drop down boxes to be disabled when the tick box is unticked and enabled when the check box is ticked?

Thanking you,

dwemh

Hi,

I think enabling or disabling of parameter controls is not possible, since we have limited access to report parameter controls.

You could have cascaded parameters instead. On selection of tick box populate the Area dropdown (by filling the Area dataset with the result of the tick box as input parameter), which in turn populates Properties based on the default Area value.

By tick box do you mean check box, because when I choose a Boolean report parameter type I am getting radio buttons!

Thanks,

JDee