|
|
 | | From: | Peter Drysdale | | Subject: | Printing on Pre-Printed Forms | | Date: | Tue, 14 Dec 2004 10:58:42 -0500 |
|
|
 | I have a report where the top two thirds is blank and the bottom one third is a bank cheque.
I require to print name, address, remittance data, etc on the top section and then - in pre printed boxes on the bottom section - print the cheque details.
I was planning to consider the cheque as a group footerband and pre-set the height to, say, 4 inches.
Is this a sensible way to tackle this job?
|
|
| | From: | Jan Hoelterling | | Subject: | Re: Printing on Pre-Printed Forms | | Date: | Tue, 14 Dec 2004 10:03:24 -0600 |
|
|
| Peter,
I wouldn't do it that way. Set the detailband to be exactly where the
printable area of the check is, then set the streamsource's MAXROW (rows per
page) property to 1. That way, you have everything in one detailband, which
you can move to fine-tune the layout, and you force one record per page. I
do the same for german "Überweisungsformular" (order for funds transfer),
which is a form that is commonly sent with invoices to the customer to
facilitate their payment.
You may also need to consider the font used as most banks scan checks and
can only support certain fonts. I have to use a specific OCR font approved
by the German Banking Industry.
HTH,
Jan
|
|
| | From: | Peter Drysdale | | Subject: | Re: Printing on Pre-Printed Forms | | Date: | Thu, 16 Dec 2004 11:40:56 -0500 |
|
|
| Jan
Thank you for your reply on Tuesday.
I still do not fully understand your suggestion.
On the top 2/3 of my form I require to print vendor name, address, etc. as well as details of the invoices being paid.
If I am using the detail band for the bank check on the bottom 1/3 of the form, what do I use to print the top 2/3?
Just to complicate the situation even further, if there are more invoices than will fit on the top 2/3, I require to select a plain sheet of paper from another tray on the printer and use it to complete the data - then return to the check tray for the next remittance.
Come back DOS - all is forgiven!
Any help will be more than appreciated.
Peter (in Scotland)
|
|
| | From: | Les Shewchuk | | Subject: | Re: Printing on Pre-Printed Forms | | Date: | Thu, 16 Dec 2004 12:35:40 -0800 |
|
|
| Are you printing one cheque at a time, or are you printing a batch of
cheques? Single cheques are easier to control, but take longer to run.
Some Tips.
-- Don't use a datamodule or a query with a relationship to build your
report. Copy the information to a flat file and print from there.
-- Build the flat file and copy the data to it yourself rather then use an
SQL command file. It's just easier to do the next step
-- Have counter and marker fields in the flat file to help control your
printing. (I don't know if you can adjust the size of a StreamFrame on the
fly, but you can use them to select paper trays before a page starts)
-- Make the "Invoices being paid" be your detail lines, not the cheque. The
Cheque rendering would become part of the footerband.
-- Place the Customer information either on the PageTemplate or in a
headerband
-- Place the cheque information on the PageTemplate at the bottom.
-- Make a very narrow footerband with one text object on it. Use the Text
object's OnRender event to turn on the Cheque information.
-- If you are doing a batch of cheques, use the headerband's PreRender to
turn off the turn off the cheque information.
Les Shewchuk
"Peter Drysdale" wrote in message
news:YNw1D444EHA.1736@news-server...
> Jan
>
> Thank you for your reply on Tuesday.
>
> I still do not fully understand your suggestion.
>
> On the top 2/3 of my form I require to print vendor name, address, etc. as
well as details of the invoices being paid.
> If I am using the detail band for the bank check on the bottom 1/3 of the
form, what do I use to print the top 2/3?
>
> Just to complicate the situation even further, if there are more invoices
than will fit on the top 2/3, I require to select a plain sheet of paper
from another tray on the printer and use it to complete the data - then
return to the check tray for the next remittance.
>
> Come back DOS - all is forgiven!
>
> Any help will be more than appreciated.
>
> Peter (in Scotland)
|
|
| | From: | Jan Hoelterling | | Subject: | Re: Printing on Pre-Printed Forms | | Date: | Thu, 16 Dec 2004 14:26:17 -0600 |
|
|
| Hi Peter,
I misunderstood your question - I thought this form was only a check form.
For the situation you describe, I would now do it just the other way around
:
Make the detailband for the area that you want to print to "normally". Put
the fields for the check on the page template itself. That way, the
detailband can never overwrite the check, and the text in the check will
always be at a fixed position. A footerband would not be suited that well to
do this, because its position would always depend on the size of the group.
Now, for the second piece of your question, selecting another slot for the
printer, that's just plain crazy . Seriously, though, not something
I've ever had to do. However, dBase allows you to have different page
templates for first versus following pages. I would use that, then put a
canRender event on something on the second page template and change the
printer tray. Not something I've ever tested, but it should work (or so I
would hope).
Hope this exaplanation makes more sense!
Jan
|
|
|
