Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

SPOOLING REPORTS WITH FOXPRO DOS 2.6a Under NT/4.0

Status
Not open for further replies.

Foxtech

Programmer
May 26, 2001
66
CA
Hi everyone,

I would like to generate my MonthEnd reports during the night and print on the next day
but I have a problem which is Window can not capture the report name. When I check in the
Network printer's proprety and I can see all my reports generated but no way to understand
that the first line is Commission Report and second line is Sales & Credit report, etc.

Note: I stoped the printer before running the job to be able to keep all reports in the SPOOLER
Printer's status : Pause
Printer: HP Laserjet 4100 PLC 5e


Here is some codes in my program Imp_all.prg

All report send to LPT1 (Set as network's printer)

Set device to printer
Report form Commission to print
Report form SaleCredit to print
Report form etc... to print
Set device to screen

The next day, I check printer's proprety and see like this:
Document Name Status Owner Page Zise Submitted

Remote Downlevel Document TINAC 602KB 10:17:19AM 10/8/01
Remote Downlevel Document TINAC 4.27MB 11:29:14AM 10/8/01


Please help me how to do in my program to allow Window can capture the Report Name or if
anyone has already the code that can do that or any solutions.

Thanks in advance



 
While the new VFP 7.0, now shows the Report Form name in the print queue, I'm unaware of any way to do this in ANY prior versions of FoxPro. Remember FPD was written to run in DOS - not under a Windows DOS emulator (like in NT/2000/XP). Also back in those days it was normally expected that you were printing direct to a printer - the PRINTSTATUS() function actually worked as long as you had a "smart" parallel port (and had the proper cable).

That being said, have you considered printing to a file (your choice on the file name), and then simply printing the file with a separate utility - when and if you want to?

Rick
 
Hi
As rick suggested you can output the reports to a text file and then print it to you convenience.

If you collect these text files in a specific directopry, you can drag and drop nto a spool directory or cut & paste to the spool directory and still keep a copy for printing, in case you need an additional copy.

There is a spooler I have described in the following link which can be set to print on any printer you want. Just click on the link below...
Here is an easy Print Spooler !
thread182-155776

Have a nice day :) ramani :-9
(Subramanian.G),FoxAcc, ramani_g@yahoo.com
 
Yamani & rgbean. Thanks a lot,
Please show me how to change th font size with Printfile, it printed in a very small characters.

thanks again

foxtech
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top