Thanks in advance for your time. Latest version 10.
I created a report from a set - the set incorporates child records that appear properly when viewed. When printing the child records in a subreport, however, the formatting or something causes the child records to print spurious extra records, duplicating the last 2 or 3 printed.
This occurs about the 5th parent record in the report, and will appear continuously thruout the report every 4 or 5 parent records. If I reverse the sort order of the report, it always occurs on the 4th or 5th parent record subreport, so it is not tied to a record, it is tied to the subreport.
If only 1 child record appears a spurious record prints every 10th parent record. So it has something to do with how the records are formatted or sized or something in the subreport. Again, the records are perfect in the set; it is how the subreport deals with some extra length in the records? I give up.
The data easily fits in the subreport; the can shrink/etc has no effect, I've redone the subreport a dozen times and it is very consistent regarding the printing of the spurious records. I've changed band properties, shring properties, you name it.
Barring a simple fix, can I exit a subreport based on some conditional criteria?
If I cannot figure out a way to exit the subreport, otherwise I could just exit when the amounts equal a bucket in the main database.
Active link tables if that makes a difference.
Thanks so much. Let me know if you need anything else...
I really don't know any other way to fix this as I think it is just a bug in the program.
I created a report from a set - the set incorporates child records that appear properly when viewed. When printing the child records in a subreport, however, the formatting or something causes the child records to print spurious extra records, duplicating the last 2 or 3 printed.
This occurs about the 5th parent record in the report, and will appear continuously thruout the report every 4 or 5 parent records. If I reverse the sort order of the report, it always occurs on the 4th or 5th parent record subreport, so it is not tied to a record, it is tied to the subreport.
If only 1 child record appears a spurious record prints every 10th parent record. So it has something to do with how the records are formatted or sized or something in the subreport. Again, the records are perfect in the set; it is how the subreport deals with some extra length in the records? I give up.
The data easily fits in the subreport; the can shrink/etc has no effect, I've redone the subreport a dozen times and it is very consistent regarding the printing of the spurious records. I've changed band properties, shring properties, you name it.
Barring a simple fix, can I exit a subreport based on some conditional criteria?
If I cannot figure out a way to exit the subreport, otherwise I could just exit when the amounts equal a bucket in the main database.
Active link tables if that makes a difference.
Thanks so much. Let me know if you need anything else...
I really don't know any other way to fix this as I think it is just a bug in the program.
Comment