We help IT Professionals succeed at work.
Get Started

Subreport print formatting help needed

Rich
Rich asked
on
546 Views
Last Modified: 2012-07-09
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.
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 17 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE