I have created a sales report in CR11, which displays the customer code, customer name and address on page header and the sales information (invoice number, item description, amount etc) in details section. The report uses Oracle sql command line. All information is captured in a single file. The problem is, when the sales data for same customer goes to next page, then only the customer code is displayed on the next page header and not the customer name and address. The details are displayed properly.

I have used two groups for the report, one on customer code and other on invoice number. The customer code is kept on the page header and invoice number on details section.

Any help would be appreciated.

Thanks Kevlray for the response, however that didn't help.

Initially I had two tables (commands), one each for the header data and details data, and the report was working perfect. However, the report was dead slow and therefore I used a single command, combining the header and details data all in one sql. Now the report is running fast, but the header data is not appearing (except the grouped field) on the subsequent pages.

Edited by RAJEEV - 29 Sep 2016 at 8:57pm