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 dwn.
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
