Solved

VFP Report Writer and NOPAGEEJECT

Posted on 2011-03-14
3
1,039 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
3 Comments
 
LVL 12

Accepted Solution

by:
jrbbldr earned 167 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 29

Assisted Solution

by:Olaf Doschke
Olaf Doschke earned 167 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 42

Assisted Solution

by:pcelba
pcelba earned 166 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

Business Impact of IT Communications

What are the business impacts of how well businesses communicate during an IT incident? Targeting, speed, and transparency all matter. Find out more in this infographic.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

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…
In this blog we highlight approaches to managed security as a service.  We also look into ConnectWise’s value in aiding MSPs’ security management and indicate why critical alerting is a necessary integration.
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar. Int…
In this video we outline the Physical Segments view of NetCrunch network monitor. By following this brief how-to video, you will be able to learn how NetCrunch visualizes your network, how granular is the information collected, as well as where to f…

724 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