VFP REPORT EXPORT IN PDF / WORD

[irfanhabib]

Dear All Respectable Experts

i am very happy i am part of your community , i reside in Pakistan and my home town not well established
but i am very much interested in programming under visual fox-pro environment, i have no idea regarding
form base programming , but my efforts continue is in progress i developed form base applications,

Presently i urgent need expert solution regarding visual fox-pro 6 formatted report , export in pdf / word format.

I humbly requested kindly advice me simple solution , my coding in following steps.

sele a
use customer
inde on custid to cd-1
set orde to tag cd-1
go top

repo form custname envi prev

Very Best Regards
irfan habib

 

[Mike Lewis]

The easiest way to export a report (or any other document) to PDF is to install a PDF printer driver. This looks just like any other printer driver. You use the application's normal Print command as usual. The main difference is that the output goes to a PDF file rather than paper.

There are dozens of such drivers available. Do a search, and you will find one.

To output to Word, the best tool I know is XFRX, from Eqeus. It can also output to PDF (without needing to install a PDF printer driver), as well as several other useful formats.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[irfanhabib]

Respected Sir MikeLewis;

Thank-You , I Generate PDF File Smoothly According To Your Expert Advice.

Very Best Regards
Irfan Habib

 

[irfanhabib]

Respected Sir MikeLewis;

This is possible in my prg file , i can set printer driver programmatically

or before printing , printer dialogue on and user select as per own requirements ?

very best regards
irfan habib

 

[Olaf Doschke]

If you uncheck "Save printer environment" in your FRX properties (Page Layout tab), the user can select the printer VFP uses via [tt]SET PRINTER TO NAME (GETPRINTER())[/tt]

Bye, Olaf.

 

[Mike Lewis]

Another point:

Make sure you use a PDF driver that allows you to set the destination for the PDF programmatically - assuming you don't want the user to see a Save As dialogue, asking them for a file name and a location for the PDF.

Almost all drivers can do that, but you might have to search the documentation to find out how to do it.

Mike

__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[irfanhabib]

Dear Sir MikeLewis

Your point is very true , when PDF File Ready For Creation , Save As dialogue Box Appear and asking
them for a file name and a location for the PDF.

I want location of the PDF & Filename , Fix Thru Programmatically.

Kindly advice me !

Very Best Regards
Irfan Habib

 

[Olaf Doschke]

That's not what VFP can do in any case. You have to use a configurable PDFF printer for that matter, BullZip PDF is one.
Also see thread184-1633942

Bye, Olaf.

 

[Mike Lewis]

I want location of the PDF & Filename , Fix Thru Programmatically.

Yes, that's the point I was making.

It's quite likely that your PDF driver allows you to set the destination programmatically. But every driver is different. If you could tell us which driver you are using, somebody here might know the answer, otherwise you will have to look at the driver's documentation or check with the vendor.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips and downloads

 

[Olaf Doschke]

Another solution in that matter is using the FoxyPreviewer Report engine extension:

https://foxypreviewer.codeplex.com/

Bye, Olaf.