Craig,
What he is asking is really quite simple,
using odbc, and VFP you can create your own vfp reports and save them as pdf files (all for free) there might be some cost to get the licence for the db2 odbc driver But having a report server/ running VFP is not all that
uncommon.

What would be necessary, would be to have active fox, or west wind or some vfp / web connection, which got fields filed out, send the data back to a running vfp app, which then created on the fly reports and fed them back to the browser. Hell for 50k and new jag, I'd consider writing such a monster myself next weekend.

my pdf converter is a place to start, to get vfp reports published on the web, but you do need something which collects the requirments of the reports, Could be as simple a cgi call, but something which fires up VFP and runs the report.

http://www.1amsoftware.com/vfpps2pdf/index.htm

ps.. Adobe Acrobat does not allow for acrobat to be used as a 'server' on a web server, So I would be careful about suggesting that one.


Bob Lee



>Fox components won't run on Linux. If you can use a Windows server and jsp supports calling COM components, you can probably do it.
>
>>That is a great idea.
>>
>>Next problem.
>>
>>We are building a data entry web app using DreamWeaver and Visual Age for Java. I've been on the team that is building this app for 6 months. So I am still learning about web development. My forte is VFP. We are trying to fiqure out how to generate reports from the DB2 database that is being used on the backend server. The server is running Linux/Websphere/Apache.
>>
>>I know how to access the DB2 data from VFP. I am wondering if I can build a report server in VFP. Can the jsp or html code call the VFP report server with some parameters (username, password, report name, etc.) and then display the resulting PDF? If so, what other tools do I need and where can I learn how to build a report server?
>>
>>Thanks.
>>
>>>You could use a PDF distiller like Adobe Acrobat or Amyuni (sp) and then display the PDF.
>>>
>>>
>>>>Is it possible to use the VFP Report Writer to generate reports for viewing and printing in a web browser? If so, how?
>>>>
>>>>Thanks.