Added. Thanks, Christophe. /charlie
From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of christophe albrech Sent: Wednesday, January 04, 2012 9:08 PM To: cfaussie@googlegroups.com Subject: Re: [cfaussie] CF Report Builder tool: any success stories? Hi Charlie, something to add to your reporting list. We use a product called YellowFin (melbourne based) as our reporting module. It's not free, but nothing short of exceptional. Basically, it is a web-based dn'd report builder that is intuitive enough for end-users to build reports with and perfectly adapted to saas vendors. I could go on forever, it's got integrated security, a web service api, ipad and android apps, connects to any datasource under the sun, and so on, but instead, I'll post a couple of links: website: http://www.yellowfinbi.com/ demo: http://demo.yellowfin.com.au/YFEntry.i4?key=efm9R7fVko%2FTX19kyvxgYnEESPtFQZ qkoBPi%2FEDeFmE%3D Cheers, Tof On Thu, Jan 5, 2012 at 4:05 AM, charlie arehart <charlie_li...@carehart.org> wrote: Yep, Barry, the CF RB is more to be used *by* developers to create build reports *for* end users, and especially to create ones that integrate specifically with CFML (passing CFQuery results into the report, for instance). If you're really wanting something to allow the end users to define reports themselves, and it's not important that the reports themselves integrate with CFML, there are any of a number of solutions more well-suited to that. I keep a list of reporting tools (no surprise) at my CF411 site, specifically: http://www.cf411.com/report Though these reports don't "integrate" with CFML (you can't pass CFQuery results directly to them, etc.), that may not be really a critical requirement. But we don't want to assume that such 3rd party reporting solutions "don't integrate at all with a CFML app". First, to be clear, such reports could certainly query the same database that CF code queries (so they're integrated in that respect). Second, most will want users to be able to "get to the reports" from links in pages shown within their CFML app, and that should be no problem. Most of these tools do create web-accessible reports, so you can link to them just like any other page (and of course, most offer substantial security if you want to lock down who should see the reports, or show different report output based on who the user is, etc.) Hope that helps. /charlie From: cfaussie@googlegroups.com [mailto:cfaussie@googlegroups.com] On Behalf Of Dale Fraser Sent: Wednesday, January 04, 2012 1:45 AM To: cfaussie@googlegroups.com Subject: RE: [cfaussie] CF Report Builder tool: any success stories? No, Our users don't do it, im not sure how well that would work, the tool is a bit quirky, but with training might be ok. I don't see why they couldn't use the tool and then have a webpage where they can upload the cfr to use. The queries can be embedded in the report. We tend to actually do the queries in coldfusion and pass the query into the report but it can work both ways. You would need a template when they upload to ask them what the input parameters are, such as start date, end date etc. Then have a coldfusion page that generates the prompts for that report. Regards Dale Fraser -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com <mailto:cfaussie%2bunsubscr...@googlegroups.com> . For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en. -- You received this message because you are subscribed to the Google Groups "cfaussie" group. To post to this group, send email to cfaussie@googlegroups.com. To unsubscribe from this group, send email to cfaussie+unsubscr...@googlegroups.com. For more options, visit this group at http://groups.google.com/group/cfaussie?hl=en.