I am creating a report for a dot-matrix printer that will be printed on preprinted multi-layer forms - each page is 8.5" x 11". The report has a sub-report consisting of a randomly long list of items (5 columns) that is about 2" high roughly centered in the right half of the page. The left side of the page has customer info and can be repeated on each page (or only on the first page.)
Currently, I have the sub-report printing items in the correct place, but if the list of items is longer than the space allowed (9 rows at Courier 10), the remaining rows are clipped off, not continued in the same spot on the next page. The sub-report is in the detail section of the main report, the rows of items are listed in the details section of the sub-report.
So the main question is: How do I get the sub report to create additional pages and print in the same spot on these if there are more items than will fit? If I have to do this in VBA, that is OK.
Do you have the Sub Report's Can Grow property set to: Yes
Without a graphic, it is not clear what you mean by:
"sub report to create additional pages and print in the same spot"
...normally a subreport will continue on the next page...
Another option I like to mention is to try using a "Grouped" Report.
This creates a report that is similar to a Main/subreport, but without all the overhead.
It is also sometimes easier to control the "grouped" (sub) records.
The Report wizard will walk you through the steps to create a Grouped report.
;-)
JeffCoachman