i have main report whith columns invoiceno, date, customer, amount. Taking from table A with above columns.

i have created sub report with columns account, debit , credit. Taking from table B with these columns. (invoiceno is link between tables A and B)

Main report is grouped by invoiceno.

i want to link main and sub report by invoiceno and i want to show sub report in main report's footer.

i want to show total debit and credit for each account regardless of invoiceno or customer.

But sub report is taking invoiceno only from main report's last group .

Suppose my main report have inv1, inv2, inv3 then
my subreport is taking accounts only from inv3

Any idea what am i doing wrong??