I'm using the latest version of Jasper Server and I'm trying to setup multiple input controls for the reports, but I can't seem to get one control to reference another. For example, I'm creating a report which will list information on a particular employee, so one control will be a Single-Select Query which will grab all possible department names from a table, and the second will be another Single-Select Query which will list all employee names based on the department chosen from the first control. I tried to reference the direct name, so the query would have "WHERE department_name = P_Department_Name" (where P_Department_Name is what I called the first control), I also tried to refence it as $P{P_Department_Name} like iReports but no go. Is this currently possible in JasperServer? Thanks for your time. Sincerely, Ricardo O'Donell
