Reporting Tools

I have a need to produce some simple reports using Cold Fusion. They are simple, text only reports, but I must have control over page layout, the ability to put row headers and the like on every page,etc. Currently, we have a VB app that generates these reports using Crystal on an Access database, but I'd like to generate the reports on the web server using a web service, and produce a link to the generated report. I'm looking at one open source tool called jasper reports (http://jasperreports.sourceforge.net) that looks like it has potential.   I wondered if anyone has successfully integrated this particular solution? Any other suggestions? Thanks. Rick Root

Upgrade to SQL2K and download/get SQL Reporting Tools - very very good and free.    _____ Sent: 18 May 2004 12:56 To: CF-Talk Subject: Reporting Tools I have a need to produce some simple reports using Cold Fusion. They are simple, text only reports, but I must have control over page layout, the ability to put row headers and the like on every page,etc. Currently, we have a VB app that generates these reports using Crystal on an Access database, but I'd like to generate the reports on the web server using a web service, and produce a link to the generated report. I'm looking at one open source tool called jasper reports (http://jasperreports.sourceforge.net) that looks like it has potential.   I wondered if anyone has successfully integrated this particular solution? Any other suggestions? Thanks. Rick Root    _____  

Is there any reason you couldn't use the crystal java report viewer to open & run the report off the server?  It works quite well, and could save you some time and headache if you have reports already made. -J ----- Excess quoted text cut - see Original Post for more -----

Jas Panesar wrote: > Is there any reason you couldn't use the crystal java report viewer to > open & run the report off the server?  It works quite well, and could > save you some time and headache if you have reports already made. Are you referring to the built in CFREPORT functionality?  That may work, but there's ZERO documentation on it in the CFMX Developer's Guide, and the Language Reference isn't much help either.    Rick

CFREPORT could concievably work very well too -- it would only generate the report and drop it to a specified file.  Have you tried the examples provided from CF 4.5+ documentation to use cfreport? if all else fails, google "+cfreport +example" without the quotes.  I was referring to a activex/java based report viewer that embeds into th web browser that allows u to run and view reports right in the browser.  You can find more info about on the devzone at: http://www.businessobjects.com/services/support/default.asp Gluck, Jas >Are you referring to the built in CFREPORT functionality?  That may >work, but there's ZERO documentation on it in the CFMX Developer's >Guide, and the Language Reference isn't much help either. > >   Rick