Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
VFP COM - FRX -> PDF - is this possible?
Message
 
À
22/04/2005 19:28:01
Information générale
Forum:
Visual FoxPro
Catégorie:
Applications Internet
Divers
Thread ID:
01007732
Message ID:
01007767
Vues:
9
Yes, this will work. The key, as Rick pointed out, is that the "Report Form.." needs to be in a COM EXE. You would then do a Createobject on that from within your VFP mtdll and call the method that has the "Report Form..".
You will need to do a DCOMCNFG on the VFP COM EXE as follows: Under Security, add Custom Access and Custom Launch permissions for the IUSR, IWAM, and ASPNET accounts. You'll also need to give Write access to those accounts for whatever directory you'll output the PDFs to. This solution will work when called from ASP or ASP.NET. For the PDF part, you'll need a PDF generator like GhostScript(free) or Amyumni and a PostScript Printer driver.
You can see an example of this at: http://www.activevfp.com/avfpdemo2/default.aspx (under PDF Reports)


>I'm considering the following solution for providing reports over the web as an alternative to crystal reports.
>
>A standard HTML form collects information such as date range, sort order and other criteria. The form is posted to an ASP page with a VFP com object that accepts these parmeters, processes the data and uses a standard VFP FRX to print the document to a PDF file using an appropriate driver. Then a response.redirect in the ASP after the VFP COM object to send the user to the PDF file to open it in the browser. Then they can save the PDF file, print it, or even email it. This solution would also allow me to use existing reports and reuse a lot of VFP code.
>
>This would be an internal Intranet app with a few dozen users at most and the reports should take only a few seconds to run.
>
>I guess my primary concern is if the VFP COM will not have the necessary permissions and accessability to print the FRX from the ASP page. So before going off and trying to build this and put it together I thought I run it by the experts on this forum.
>
>Thanks in advance!
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform