Solved

VFP Report Writer and NOPAGEEJECT

Posted on 2011-03-14
3
966 Views
Last Modified: 2012-05-11

I use "NOPAGEEJECT" to combine several reports to a single PDF file.
I don't always know which is the last page, so I don't know when to remove the NOPAGEEJECT clause.

What happens is, the report is not created till I exit the app or the spooler times out.
I tried using "SET PRINTER TO " to close the spooler, but it doesn't seem to work.

Any help is appreciated.
Michael
0
Comment
Question by:MichaelKatz
3 Comments
 
LVL 12

Accepted Solution

by:
jrbbldr earned 167 total points
Comment Utility
A question:

"I use "NOPAGEEJECT" to combine several reports to a single PDF file."
OK

"I don't always know which is the last page, "
Why not?

Aren't you creating a cursor/table of records which you then submit to your REPORT FORM?

If so, you should 'know' when you are changing among your 'Several Reports" from Report Form n to Report Form n+1 and you should also 'know' at the same time how many records are left in your report data table.

That or some other method should be able to 'tell' you when you are beginning your last page.

Good Luck
0
 
LVL 29

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 167 total points
Comment Utility
I agree to jrbbldr.

And if users are interactively picking data to append and you create the pdf underway and therefore can't determine when users are finished, then let that print to a TXT file and repeat the process afterwards so you know which data and how many reports and what is the last.

In short, first aggregate what you want to print, then print.

Bye, Olaf.
0
 
LVL 41

Assisted Solution

by:pcelba
pcelba earned 166 total points
Comment Utility
Don't use SET PRINTER TO but create one empty report which will be executed without NOPAGEEJECT at the end.
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
HOW TO: Upload an ISO image to a VMware datastore for use with VMware vSphere Hypervisor 6.5 (ESXi 6.5) using the vSphere Host Client, and checking its MD5 checksum signature is correct.  It's a good idea to compare checksums, because many installat…
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

762 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

7 Experts available now in Live!

Get 1:1 Help Now