How to enable/disable report parameters based on user selection?

[Mohamed]

I have to show a report of employees.

This will have columns ID, Name, Designation, Department etc.

User should have 2 options (using report parameters) to view report

1. Based on department

    If user chooses department option, a drop should be loaded with all departments

2. Based on designation

    If user choose designation, a drop should be loaded with all designations.

Is there any way to provide this functionality (selection of either department or designation) using report parameters?

[Stef]

Hello Mohamed,

Please check my post in the How to make Report Parameter visible based on value of another report parameter selection forum thread. It list some options coming to my mind.

Using cascading parameters - one controlling the available values of a second one is suitable for the described scenario.


I hope this helps.

Regards,
Stef
Telerik