Dynamic PDF reports from SQL data via JSP Tomcat

[Pierre Lessard]

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