?
Solved

VFP Report Writer and NOPAGEEJECT

Posted on 2011-03-14
3
Medium Priority
?
1,049 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 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 30

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 42

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 Orion Papers

Are you interested in becoming an AWS Certified Solutions Architect?

Discover a new interactive way of training for the exam.

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…
We are witnesses that everyone is saying that our children shouldn't "play" with a technology because it is dangerous. This article is going to prove that they are wrong.
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…
In this brief tutorial Pawel from AdRem Software explains how you can quickly find out which services are running on your network, or what are the IP addresses of servers responsible for each service. Software used is freeware NetCrunch Tools (https…
Suggested Courses

765 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