The most dynamical thing I've found so far is using JasperServer. It doesn't quite let you create free-form reports, but it has a lot of stuff you can use that lets the end user configure a report, and can produce reports in like 15 different formats.
It is awesome. Eventually I'll get around to writing an HTML-based WYSIWYG JasperReport editor, for use with the cfjasperreport tag, which *will* be a free-form type of deal. The XML used for JasperReports is pretty easy to write, if you need free-form, you could whip up an editor and use the cfjasperreport custom tag. Another solution is to leverage iReport for the actual report design, with the JasperServer plugin. iReport is awesomeness too. :Den -- Madness is rare in individuals - but in groups, parties, nations, and ages it is the rule. Friedrich Nietzsche On Thu, Oct 7, 2010 at 8:20 AM, Richard White wrote: > > thanks for the reply. correct me if im wrong as although i have looked at it > i dont know it in depth, i thought it was inflexible as it wouldnt allow > users to quickly create their own reports as they would in ms access > > thanks > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology-Michael-Dinowitz/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:337936 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm