Hello Readers. I've to make a Customer's Invoice report
which first shows all the invoices of specific customer with specified dates in the following manner
CustomerName
Customer 1
Inv#    Grand Total          IvnDate
1-2011          15000               01-Jan-2011
6-2011          30000               01-Jan-2011
35-2011        35000               02-Jan-2011
now once these records are shown first i then want to display the detail of each invoice after the first above pulled records end.
Detail for Inv# 1-2011
Product Qty Rate Total
Product1           5          20          100
Product2           6          15           90
--------------------------------------------------
Detail for Inv# 6-2011
Product Qty Rate Total
Product6           10          20          200
Product7           15          10           150
--------------------------------------------------
Detail for Inv# 35-2011
Product Qty Rate Total
Product6           10          20          200
Product7           15          10           150

for this to achieve i have an idea i.e. to use subreport for detail of each invoice and group our main report by invoice # and link main and subreport via saleid (Primary key)
till here the data pulled is accurate but it doesn't display as my client wants mentioned above.
I am looking forward to your guidance
Thanks in advance.