Printing Cheques

rbuser

Hi All,

I'm using Delphi 3 and ReportBuilder Pro Ver 4.21 for Delphi 3 with an MS
Access database.



I need to print out a single cheque on demand. I use 2 Queries, one for the
cheque data: Cheque Number, Date, Name, Address, and Amount. The other query
is the details of the invoices the cheque is paying: Invoice Number, and
Amount. Each cheque could be paying between 1 and 50 invoices. They are
joined on the ChequeNumber field. Each query has its own Pipeline.



My problem is printing on an 8.5 X 11 sheet of paper perforated in 3
sections. Top 1/3 is the cheque, no problem. Middle section is the details
of the invoices, no problem. Bottom 1/3 is an exact repeat of the middle
section (the invoice details), PROBLEMS.



I may need to go to multiple pages for the last 2 sections, without
reprinting the top section (the cheque).



I would also prefer to print the invoice detail three across each line (I
don't care if they are sequential across the line or sequential by columns
within their section) to avoid using multiple pages as much as possible.



Thank you for your consideration.

Phil

nardmoseley

The top 1/3 can be handled by a group header.

For the middle and bottom 1/3's try using a subreport for each 1/3. Set
subreport PrintBehavior to pbFixed and set the subreport's Height to define
the page area in which the detail lines can be printed. Set subreport
TraverseAllData to true.

You may need to use 2 detail datapipelines to print the middle and bottom
1/3's. Newer releases of ReportBuilder enable multiple reports/childreports
to be connected to the same datapipeline, however older versions do support
this configuration.

Once you get the above working, try configuring the subreports to print in 3
columns.


--
Nard Moseley
Digital Metaphors Corporation
www.digital-metaphors.com