Classic ASP ComponentsDiscussions specific to components in ASP 3.
Welcome to the p2p.wrox.com Forums.
You are currently viewing the Classic ASP Components section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
Has anyone out there generated a PDF file using ASP on the server with SQL data? With so many third-party products, it's hard to know which one is best. Any feedback for processes or products would be great.
We currently generate management reports in HTML code and display them in the browser from our intranet. We'd like to generate PDF documents to email to the user as well. The data is pulled from SQL databases using ADO and VBSCript. The output is what looks like a management report displayed in HTML in the browser. It will have headings, bolding, underlining, company logo image, page numbers, etc.
We use activePDF and seems to work well. You might look on http://www.planetpdf.com for more tools. Also the forums on pdfzone.com is filled with very knowledgeable programmers who may have more suggestions.
I use Crystal Reports 9.0. The RDC, Report Designer Component, allows me to create the report in Crystal, formatted the way I like, and allow my ASP page to call the report and pass certain criteria to it then generate an identical PDF on the fly. Internal users can also run the report normally without ASP. It's pretty quick as well.
The problem with displaying the reports in HTML are that the user can modify them.
Suppose you have a contract that you would like your user to print out from your site, sign it, and send it back. With HTML the user could virtually modify the conditions of the contract and it may go undetected from your internal staff. That is until you're made aware of it during a law suit or something.
Even if you disable right-clicking on an HTML report and display it in a popup window with no toolbar, all the user would have to do to get the source is hit Ctrl-N to open it in a new window normally.