Hello to all,
I have a report that gets its data from a cursor. The cursor is a list of invoices sorted by customer then by invoice.
In the report I have a data grouping on the customer number. In the footer of the customer grouping, there is 6 lines printed. I also have data in the page footer which comes from the cursor.
The problem I have is that: when all the detail section prints on page #1 and the group footer alone prints on page #2, then the data printed on the page footer of page #2 belong to the next customer (which should normally start printing on next page). BTW the customer grouping is setup so that each group start on a new page.
I tried to put my data into reports's variable that refresh at the end of customer grouping, it moves the problem but doesn't fix it.
Am I trying to do something impossible?
Diane Robitaille eng.