We have a VFP 6 system that is generating commission statements for Agents twice a week. Currently, these statements are being mailed...we would like to provide access to these via the web to get the info out quicker and eliminate mailing costs. Does anyone have suggestions on the best way to do this. Right now I see the alternatives as:

1. Run something in VFP locally to create separate PDF files for each statement, then upload files to web server using predetermined naming scheme. Users can login to web server and gain access to only their PDF files.

2. Upload data to web server and create PDF report 'on the fly' from webserver data based on SQL select statement.

I am familiar with ColdFusion on the web server, but don't know if I can create PDF files using ColdFusion.

Any ideas? Thanks,
Doug