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 Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
A Fox 2.6 report convert to PDF
- Thread starter Armida
- Start date
infinitelo
Programmer
- Mar 7, 2001
- 319
Hi, Ive seen a lot a threads on this topic, and ill try to do it justice. First of all on a pdf output. you have to have adobi page maker version that will act as a print driver. not sure how to do this, you will have a few problems with wizard built reports in that your line may or may not show up corectly.
As for html, this is my favorite method of making fox26 make cool output.
ie:
use <filename> index <whatever> && say fields state,stcount
set printer to file c:\temp\outfile.htm
set printer on
?"<html>"
?"<body>"
?"<h2><i><b><center>"
?"This is the ultimate way to print data"
?"<table border=3>"
tot= 0
scan
?"<tr><td>"+state+"</td><td>",stcount,"</td>"
tot = tot+stcount
endscan
?"<tr><td>your state total is</td><td>",tot,"</td>"
?"</table>"
?"</body>"
?"</html>"
set printer to
set printer off
!explorer c:\temp\outfile.htm && win98 or higher
the trouble with being the early bird: sometimes you get the worm... sometimes you get the bird.
As for html, this is my favorite method of making fox26 make cool output.
ie:
use <filename> index <whatever> && say fields state,stcount
set printer to file c:\temp\outfile.htm
set printer on
?"<html>"
?"<body>"
?"<h2><i><b><center>"
?"This is the ultimate way to print data"
?"<table border=3>"
tot= 0
scan
?"<tr><td>"+state+"</td><td>",stcount,"</td>"
tot = tot+stcount
endscan
?"<tr><td>your state total is</td><td>",tot,"</td>"
?"</table>"
?"</body>"
?"</html>"
set printer to
set printer off
!explorer c:\temp\outfile.htm && win98 or higher
the trouble with being the early bird: sometimes you get the worm... sometimes you get the bird.
AMYUNI Software makes a PDF and a HTML print driver that works with any version of FoxPro or Word Or Excel Or etc.. They are $99.00 each, Or that is what they were when I bought them 2 years ago.
David W. Grewe
Dave@internationalbid.com
David W. Grewe
Dave@internationalbid.com
Go to and enter "PDF Printer" or "HTML Printer" into their search window and you will get a variety of Shareware and Freeware results.
Good Luck,
jrbbldr
jrbbldr@yahoo.com
Good Luck,
jrbbldr
jrbbldr@yahoo.com
Rick....
"The easiest way to do this is buy a PDF printer driver, and switch the current printer to it before printing the report."
A question for you....so you would not need to buy a copy of Adobe's Acrobat *Writer* ($450?) program?
How would you programaticaly change the printer to the PDF driver in 26?
Regards - Wayne
"The easiest way to do this is buy a PDF printer driver, and switch the current printer to it before printing the report."
A question for you....so you would not need to buy a copy of Adobe's Acrobat *Writer* ($450?) program?
How would you programaticaly change the printer to the PDF driver in 26?
Regards - Wayne
Wayne,
Yes, you'd need to spend the $450 for each user that wants to be able to print to the PDF "printer", if you go the Acrobat route. The other responders have pointed you to other (cheaper) alternatives - I actually use the 5D PDF driver.
To change the printer, you can add the PROMPT clause to your REPORT command, or you can prompt the user to change it with SYS(1037). You can also change the default printer using the code in - "HOWTO: Change the Default Windows Printer from FoxPro (Q103645)".
Rick
Yes, you'd need to spend the $450 for each user that wants to be able to print to the PDF "printer", if you go the Acrobat route. The other responders have pointed you to other (cheaper) alternatives - I actually use the 5D PDF driver.
To change the printer, you can add the PROMPT clause to your REPORT command, or you can prompt the user to change it with SYS(1037). You can also change the default printer using the code in - "HOWTO: Change the Default Windows Printer from FoxPro (Q103645)".
Rick
- Status
Similar threads
- Locked
- Question
