crystal report 7 - linking to sub report

[harshadaj]

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??

 

[IanWaterman]

Report is doing what you asked it to do ;-)
Placing Subreport in report footer and linking by invoice will always link on last record.

If you want a summary of CR/DR for all invoices and customers then do not link it at all.

If you have a date range make sure the SR has the same date range too.

Ian