On Tue, Mar 18, 2008 at 6:36 AM, C. Hatton Humphrey <[EMAIL PROTECTED]> wrote: > New job uses JasperReports for their PDF report generation. They're > running a Tomcat server to provide the services on a different port. > While digging around I found messages and blog posts pointing to the > fact that CF7 (and by assumption CF8) use JasperReports for the > CFReport functionality, is this correct?
Ja, but with CF7 it's an old version, and there are library conflicts with the newer stuff. I think I found a way to run it on CF8, using a classloader, but it's untested. And I don't even know what version 8 has, or if it's still in there, even. I switched to using JasperServer, which has been just freaking awesome. That, my friend, is the way to do reports! Offload that busywork to another server, and hopefully, the replication database or something. > If it is, how difficult would it be to migrate the existing reports to CF8? If you're thinking "convert them into CFREPORT reports", I don't know how possible that is. You could probably get CF to read the .JRXML files (or the jasperpring files, etc.) and generate/fill the reports without too much hastle-- I've got plenty of example code and whatnot, that doesn't exemplify best practices, but does get the job done. Compiling/filling reports, using a DSN, or passing in SQL/queries... I got so into it for a while I was storing the compiled reports in the DB... But the real answer is: don't. You want that report server (I'm assuming it's jasperserver that's running?) doing it's thing, without needing CF. Reports, and especially nifty reports, can freaking bog a lively system doooown. Best to, as I said, have the report server be pulling it's data from a separate, replicated db, even. Stick to using jasperserver, and just use the webservice to pull stuff into CF. I've got some code that will do that; run reports from the webservice. Just give it a resource URL and user credentials, and pick the format. I just finished a lazy-loading tree to traverse the directory structure of the report repository, too, that you're welcome to. Let's folks drill down through the folders, and pick their report. Guess I'll add check-boxes, eventually, to handle multiples... The tree is using the dojo 1.0 JS library, which freaking roxerz. I've been meaning to give the jasperserver webservice code a once over and put it somewhere public, like frameworkforge (I've already got an MG actionpack using it), but simply haven't done so as yet. If you've got any questions, I love to share what I know, especially about things like jasperserver, which have made my life waaay easier. You know iReport ties right into it's repository? iReport is a swell, just swell GUI report builder. And it's cross-platform (java). :-) -Denny -- Wolverines! ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;160198600;22374440;w Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:301629 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
