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 for example, with the rest on still 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'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 for example, with the rest on still 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'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