I am having an issue getting a subreport to link to the main report. I need to give the user different input values in order to genereate the report. For instance, I have 5 parameters established (city, cust_id, job_number, state, zipcode), any of which can be left blank which tells the QRY to grab all: where CASE WHEN $P{cust_id} = 0 THEN cust_contact.id > 0 ELSE cust_contact.id = $P{cust_id} END and CASE WHEN $P{city} = 'ALL' THEN cust_contact.city like '%' ELSE cust_contact.city ilike $P{city} END and CASE WHEN $P{state} = 'ALL' THEN cust_contact.state like '%' ELSE cust_contact.state ilike $P{state} END and CASE WHEN $P{zipcode} = 'ALL' THEN cust_contact.zip like '%' ELSE cust_contact.zip ilike $P{zipcode} END and CASE WHEN $P{job_number} = 0 THEN j.id > 0 ELSE j.id = $P{job_number} END When the cust_id and the job_number is used as the input, the report generates correctly and the subreport is populated within the main report as expected. When I want to see ALL customers in the state of NJ (leaving cust_id, job_number, etc as all and selecting NJ as the state), I get a main report with a subreport in it hundreds of times. Is there a way to have the subreport link back to the main report using the job_number so that each report will only have one subreport generated inside of it? Thanks in advance!