Question: I have a report with a drill through functionality set up. On the parent report I have two parameters to narrow the query by the deliverydate (@startdate and @enddate) If the reportuser clicks on a row "Orderaccount" it will op the "child" report, The value "Orderaccount" is passed through fine, but the "@startdate and @enddate" aren't. Could it have to do with the fact that "@startdate and @enddate" are used in the Where cause in the child report? How can I pass through the "@startdate and @enddate" from the parent to the child? Child query: SELECT VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDTABLE.NAME, VENDPACKINGSLIPTRANS.ITEMID, VENDPACKINGSLIPTRANS.NAME AS ItemDescr, VENDPACKINGSLIPTRANS.PURCHUNIT, SUM(VENDPACKINGSLIPTRANS.QTY) AS Aantal, SUM(VENDPACKINGSLIPTRANS.VALUEMST) AS Bedrag, INVENTDIM.INVENTSIZEID, INVENTDIM.INVENTCOLORID, PURCHLINE.AGA_DESTINATION FROM VENDPACKINGSLIPJOUR INNER JOIN VENDPACKINGSLIPTRANS ON VENDPACKINGSLIPJOUR.PACKINGSLIPID = VENDPACKINGSLIPTRANS.PACKINGSLIPID INNER JOIN VENDTABLE ON VENDPACKINGSLIPJOUR.ORDERACCOUNT = VENDTABLE.ACCOUNTNUM AND VENDPACKINGSLIPTRANS.DATAAREAID = VENDTABLE.DATAAREAID AND VENDPACKINGSLIPJOUR.DATAAREAID = VENDTABLE.DATAAREAID INNER JOIN PURCHTABLE ON VENDTABLE.DATAAREAID = PURCHTABLE.DATAAREAID AND VENDPACKINGSLIPJOUR.PURCHID = PURCHTABLE.PURCHID INNER JOIN PURCHLINE ON PURCHTABLE.PURCHID = PURCHLINE.PURCHID AND VENDTABLE.DATAAREAID = PURCHLINE.DATAAREAID AND VENDPACKINGSLIPJOUR.PURCHID = PURCHLINE.PURCHID INNER JOIN INVENTDIM ON PURCHLINE.INVENTDIMID = INVENTDIM.INVENTDIMID AND VENDTABLE.DATAAREAID = INVENTDIM.DATAAREAID WHERE (VENDPACKINGSLIPTRANS.DELIVERYDATE >= @startdate) AND (VENDPACKINGSLIPTRANS.DELIVERYDATE <= @enddate) GROUP BY VENDPACKINGSLIPTRANS.ITEMID, VENDTABLE.NAME, VENDPACKINGSLIPTRANS.NAME, VENDTABLE.DATAAREAID, VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDPACKINGSLIPTRANS.PURCHUNIT, INVENTDIM.INVENTSIZEID, INVENTDIM.INVENTCOLORID, PURCHLINE.AGA_DESTINATION HAVING (VENDTABLE.DATAAREAID = N'zm') AND (VENDPACKINGSLIPJOUR.ORDERACCOUNT = @orderaccount) ORDER BY VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDPACKINGSLIPTRANS.ITEMID Parent query: SELECT VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDTABLE.NAME, VENDPACKINGSLIPTRANS.ITEMID, VENDPACKINGSLIPTRANS.NAME AS ItemDescr, VENDPACKINGSLIPTRANS.PURCHUNIT, SUM(VENDPACKINGSLIPTRANS.QTY) AS Aantal, SUM(VENDPACKINGSLIPTRANS.VALUEMST) AS Bedrag FROM VENDPACKINGSLIPJOUR INNER JOIN VENDPACKINGSLIPTRANS ON VENDPACKINGSLIPJOUR.PACKINGSLIPID = VENDPACKINGSLIPTRANS.PACKINGSLIPID INNER JOIN VENDTABLE ON VENDPACKINGSLIPJOUR.ORDERACCOUNT = VENDTABLE.ACCOUNTNUM AND VENDPACKINGSLIPTRANS.DATAAREAID = VENDTABLE.DATAAREAID AND VENDPACKINGSLIPJOUR.DATAAREAID = VENDTABLE.DATAAREAID INNER JOIN PURCHTABLE ON VENDTABLE.DATAAREAID = PURCHTABLE.DATAAREAID AND VENDPACKINGSLIPJOUR.PURCHID = PURCHTABLE.PURCHID INNER JOIN PURCHLINE ON PURCHTABLE.PURCHID = PURCHLINE.PURCHID AND VENDTABLE.DATAAREAID = PURCHLINE.DATAAREAID AND VENDPACKINGSLIPJOUR.PURCHID = PURCHLINE.PURCHID INNER JOIN INVENTDIM ON PURCHLINE.INVENTDIMID = INVENTDIM.INVENTDIMID AND VENDTABLE.DATAAREAID = INVENTDIM.DATAAREAID WHERE (VENDPACKINGSLIPTRANS.DELIVERYDATE >= @startdate) AND (VENDPACKINGSLIPTRANS.DELIVERYDATE <= @enddate) GROUP BY VENDPACKINGSLIPTRANS.ITEMID, VENDTABLE.NAME, VENDPACKINGSLIPTRANS.NAME, VENDTABLE.DATAAREAID, VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDPACKINGSLIPTRANS.PURCHUNIT HAVING (VENDTABLE.DATAAREAID = N'zm') ORDER BY VENDPACKINGSLIPJOUR.ORDERACCOUNT, VENDPACKINGSLIPTRANS.ITEMID

When you look at the Subreport properties, on the parameter tab, are StartDate and EndDate listed in the Parameters? what are they set to? Make sure they are set to the parent report StartDate and EndDate parameters.

When you look at the Subreport properties, on the parameter tab, are StartDate and EndDate listed in the Parameters? what are they set to? Make sure they are set to the parent report StartDate and EndDate parameters. I'm not sure what you mean. I have 3 variables in the subreport @orderaccount, @startdate and @enddate. Could you explain where I can set the parameters to the parent report. (I thought that the parent report passes the parameters through to the subreport). Edwin

I solved it. On the parent report, I had to tell with parameters to pass through. If I selected the child report, I could select (via de dropdown) the parameters. On the right site I could't, there were no parameters available. I had to go to the FX button and double click in the expression editor on the variable startdate and enddate. That did the trick. Edwin