The last line of data of every page is also the first line on the next page. I have not encountered this before and I cannot see how it is happening or how to correct it.
The report has three groups and the 3rd group has 3 details lines. It is the 2nd detail line that repeats. The repeating line has not encountered a group change, nor has the 3rd detail line been triggered. It is a simple report that lists a line of data and prints it onto the report.
The SQL is grouped by the same grouping of the report. Yes, data does repeat in the SQL, which would be expected for the grouping. However, the data does not repeat in a group of the data returned by the SQL statement, so there is no reason for this data repetition.
It is not restricted to any one piece of data in the report. The line that repeats is the last line on a page. Clicking on the next page of the report shows the last line of the previous page is the first line of the new page. This is true whether the report is viewed or printed.
Does anybody have any suggestions?
Thank you.