Improve company productivity with a Business Account.Sign Up

x
?
Solved

VFP Report Writer and NOPAGEEJECT

Posted on 2011-03-14
3
Medium Priority
?
1,084 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 668 total points
ID: 35131813
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 31

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 668 total points
ID: 35132657
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 44

Assisted Solution

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

Featured Post

The 14th Annual Expert Award Winners

The results are in! Meet the top members of our 2017 Expert Awards. Congratulations to all who qualified!

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

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…
Current business processes need to constantly adapt to changing threats. Surely we do not want to be the next victim. We can take an active stance and stay agile. This article shares some tips.
Hi, this video explains a free download that you can incorporate into your Access databases, or use stand-alone for contact management. Contacts -- Names, Addresses, Phone Numbers, eMail Addresses, Websites, Lists, Projects, Notes, Attachments…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

595 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