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) FacilitiesLocationsADoctor Jones Doctor SmithBDoctor Walker Doctor BrownSo 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: https://community.jaspersoft.com/questions/542182/selecting-parameter-values-sql-query but I need to take it just one step further. Anyone know how to do this? Thanks, Mike