For Jasperserver I need to be able to have two parameters for the report to be based on querys, and I need the results of the second parameter "lookup" to be based on the results of the first parameter value. I know it sounds confusing, so here is an example.
I have multiple facilities (buildings), and in each facility there are multiple locations (departments). I want to first select facility A from the first parameter, then have the second parameter only have locations from facility A (filtered)
So when I select "A" for my facility in the first parameter, I want to only see "Doctor Jones" and "Doctor Smith" in the second parameter, not all 4 doctors.
I know how to do the query based parameter from this excellent, post:
but I need to take it just one step further.
Anyone know how to do this?