I am attempting to build a single report that will have its Record Selection based on a parameter, which in turn will affect the need to choose further parameters depending on the initial one chosen.
The first parameter (Scope) needs to have the following values: Department, Team, Technician
-If Department is chosen, field 'Department'=Dept1(set value)
--If Team is chosen, that needs to call a secondary parameter 'Team'. From Team, a list of values can be chosen and the chosen value would be used for field 'Team'.
--If Technician is chosen, that needs to call a secondary parameter 'Technician'. From Technician, a list of values can be chosen and the chosen value would be used for field 'Technician'.
If I put all of the parameters into the Record Selection using an If/Then statement, I'm prompted to enter values for everything reagrdless of what is chosen for the first parameter. I know I would run into the same issue if I went the subreport/suppress route if I did each as its own report.
Is there a way to do this without having entirely separate reports?
Start Free Trial
