[dba-Tech] PDF from ASP

Dear Group,

I'm going to be starting a project to convert an Access 2000 application to a web-based front end with a SQL Server back end. I've told my client that reports on the web leave a lot to be desired though several HTML pages can be created to represent different sections on a report.

My client wants to know why a report generated on the web can't be formatted with Adobe Acrobat. That is, when SQL Server returns the data and is ready to spew it out into the web page layout, what about stuffing the data into a PDF file instead?

My gut reaction is that this isn't possible; or, if it is, it would require some pretty fancy programming.

I tried to tell him that converting an Access report into a PDF document with one of the many PDF converters is a whole different animal from creating a PDF document on-the-fly on the web from a SQL query.

Any thoughts?

Regards,

Steve Erbach
Scientific Marketing
Neenah, WI
920-969-0504

RUSH LIMBAUGH: After Pearl Harbor, we didn't do the Pearl Harbor committee investigation until after the war was over. 

KAREN HUGHES: And no one suggested that the president should apologize for the Japanese attack on our country.