Solved

VFP Report Writer and NOPAGEEJECT

Posted on 2011-03-14
3
1,002 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
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 41

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

Live: Real-Time Solutions, Start Here

Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

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…
Having trouble getting your hands on Dynamics 365 Field Service or Project Service trial? Worry No More!!!
This Micro Tutorial will give you a basic overview how to record your screen with Microsoft Expression Encoder. This program is still free and open for the public to download. This will be demonstrated using Microsoft Expression Encoder 4.
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

786 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