Printing a Multi-PageCheck

[DataMgmtSolutions]

I know there is an easy solution to this but I am just not 'with it' today.

I need to generate a multi-page check to one printer with one paper source -- meaning the first page will be printed on check stock and the subsequent pages will be printed on plain paper.

I need a means of knowing before the report is generated if there will be a second page (or more. Then after page one has printed (on the check stock) I need the report to pause so the user is prompted to add X number of sheets of plain paper to complete that check/report.

Any ideas??

 

[Auguy]

You will have to process the table or cursor yourself to determine the correct number of plain paper needed. To do this I think will require you to issue a separate report for each check. Why don't you print all of the checks in one pass and then the plain paper versions in a second pass. I do something very similar to this and it works well. Just make sure you print check numbers on everything so they can be matched to the checks easily.


Auguy
Sylvania, Ohio

 

[Stella740pl]

One of the ways was just suggested to you.

It might be also easier to create two reports instead.

You can also run report with a preview and a prompt for printer:

REPORT FORM myReport TO PRINTER PROMPT PREVIEW

so the users could see for themselves how many pages are there, and print the first page separately, then all the rest on a different paper.

Also, you can run report more than once.

Check out this faq184-2911 on how to calculate the number of pages in a report in advance using _PAGENO system variable . (In newer versions of VFP (I believe, starting 8) there is another system variable available, _PAGETOTAL, but when you use it, VFP just performs two passes through the report itself, with the first pass not visible or printed.) Then you can prompt your user before starting the print job to insert a check form and N pages of plain paper at once.

 

[DataMgmtSolutions]

Thanks Auguy - I had not considered making a couple passes - which would work for one of my clients who has continuous feed check stock.

I had hoped there was a more elegant way of counting lines/pages,subtotals, etc. but will do it the 'fashioned way'.

 

[DataMgmtSolutions]

Thanks Stella - PageCount is exactly what I was looking for.
Lisa

 

[Stella740pl]

Lisa,
Welcome to the VFP community here.
Glad this helps you.