I have a Report that I've invested a lot of time in, and it's not working correctly . It has two Groups, each with about 16 sections (GroupHeader1a, GH1b...GH1q), the second one has six sub-reports in the last six sections.
The problem is that it sometimes repeats data on the next page. If it has printed GH1a thru GH1f and hits the bottom of the page, sometimes it will repeat that data on the next page continuing on (GH1a thru GH1n again for example, with the rest on still the next page.) Appears it could be any section. It goes to a point, hits the bottom of the page, then repeats that same data (starting from GroupHeader1a) at the top of the next page.
I've copied the SQL Statement from "Show SQL Query" and pasted it into Enterprise Manager, and the resulting recordset is correct (so I know there is nothing wrong with the SQL string, or duplicated data in the DB.)
I tried exporting to Word, and it duplicates the same way. It seems to (sometimes) start printing a Grouping over when it hits the bottom of the page.
I've also tried every setting of "Keep Together", "Keep Object Together", "Close Border on page Break", and "Can Grow"... that makes any sense to try.
Any advice?
Thank you.
Good Luck!
WindUp
The problem is that it sometimes repeats data on the next page. If it has printed GH1a thru GH1f and hits the bottom of the page, sometimes it will repeat that data on the next page continuing on (GH1a thru GH1n again for example, with the rest on still the next page.) Appears it could be any section. It goes to a point, hits the bottom of the page, then repeats that same data (starting from GroupHeader1a) at the top of the next page.
I've copied the SQL Statement from "Show SQL Query" and pasted it into Enterprise Manager, and the resulting recordset is correct (so I know there is nothing wrong with the SQL string, or duplicated data in the DB.)
I tried exporting to Word, and it duplicates the same way. It seems to (sometimes) start printing a Grouping over when it hits the bottom of the page.
I've also tried every setting of "Keep Together", "Keep Object Together", "Close Border on page Break", and "Can Grow"... that makes any sense to try.
Any advice?
Thank you.
Good Luck!
WindUp