prasadvel

That helped

I had the below issue where the report is not giving the right page numbers as explained below.is there a way where the report prints page of pages for each customer invoice separately? format --Expected outcome Customer-1 (two pages for each customer id) ----invoice details Page 1of 2 page 2 of 2 page footer End of invoice customer -2 ----invoice details Page 1of 2 page 2 of 2 page footer End of invoice page footer End of invoice -------------Current issue currently its printing as (2 pages for each customer) customer -1 page 1 of 4,page 2 of 4 customer -2 page 2 of 4 ,page 4 of 4

How can we use the variables from main to sub report? or should we use the same sql again in sub report as i need to get the summary from mainreport

Subreport requirement Req1- Generate store orders invoices for all customers of that day which is using all bands of the report Req-2- Provide summary of the above req1 customers ,their address,value shipped in final summary page please let me know where to place this subreport in the main template as all bands are occupied.