PDF / Web-based Reporting

[shmiller]

A couple of questions
Does anyone know of a way to export a report to PDF format?
Has anyone used Access Reports with a web-based app? We would like to convert some of our VB apps to ASP, but some of them make use of Access to print a lot of reports. We want users to be able to print these reports on their local printers. That's why I thought about running the report on the server then exporting it to PDF where we could link to it. Any Ideas?

Thanks,
Shanti

 

[vanillapod]

I use an access backend, with a front end that is always open on one PC. Other users then access the data through an ASP frontend, they request reports by putting data into a table in the backend database, the frontend database then uses the form timer event to get that information and print the relevent report to a set directory, users can specify file type and all that. The ASP frontend then links to that file ready for viewing, downloading ect. Maybe not the best solution but it seems to work for me. There's a link to printing pdf from access at, but i haven't got the code to work:

http://www.mvps.org/access/reports/rpt0011.htm