Pete, You may want to look into Cocoon: http://xml.apache.org/cocoon It allows you to build a pipeline that returns dynamically generated PDFs to the request without storing them on the filesystem. You provide the SQL data (formatted as XML) and an XSL stylesheet to do the transform...then you pass all that to Cocoon and it generates the FO and passes it to the FOP processor to generate the PDF. Bob Hitchins Senior IT Business Analyst Cargill Crop Nurtrition -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Saturday, April 19, 2003 6:45 PM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Dynamic PDF reports from SQL data via JSP Tomcat
Hello! I'm just new to FOP, but already succeeded in embeding FOP in a JSP. But now, would like to know the best way with the minimum install possible to generate PDF reports based on a SQL select request? In this by calling a JSP page from Tomcat? Can anyone can tell me the way? XML report template ----(SQL select from a database)---> XML report with the data ----(XSL style sheet)----> PDF generated on the fly with JSP is this possible? any better way to do it? What JAR to install? What API or other packages like XALAN ? Thank you! Pete --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
