We have both Crystal Reports and SQL Server 2008 Reporting Services at work. While they are not super customized, they do serve the purpose of allowing users to run some rudimentary reports.
However, neither is ColdFusion-based, and it sounds like that is what you are looking for. On Sun, Jan 3, 2010 at 7:51 PM, <[email protected]> wrote: > > I'm not totally sure what you are after-- I Googled "Quick Query" and > all I could find was a MS Access plug-in. > As for allowing your users to write their own queries, I really can't > imagine doing this without an interface that enforced your specific > business rules and limited them from running something really stupid. > This is probably why the "query builders" I have seen before were > specific to an application and its entities/relationships. > > There may or may not be something built in CF out there, but if you > really trust your users to run anything they want on the DB, then > install Query Analyzer and give them a log in with only select > permissions (The thought of that kind of scares me...), or try to define > a handful of reports that funnel them in a specific direction where you > can control the SQL statement, but they can filter, group, and sort by > themselves. > > ~Brad > > > -------- Original Message -------- > Subject: Query/Report Builder > From: Tom Jones <[email protected]> > Date: Sun, January 03, 2010 5:12 pm > To: cf-talk <[email protected]> > > > Hello, > I have been looking through the archives but really did not find much on > this. I'm looking for a web based query builder. I want to let my users > create their own queries. > It must have been done before, so I really dont want to re-invent the > wheel. I came across something called "Quick Query" but it's a ASP.Net > thing and I'm not running on Windows nor do I really want to use ASP. > :-) > > Are there any projects or something that will give me a head start or do > I need to write it from scratch? > > Thanks, > tom > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Want to reach the ColdFusion community with something they want? Let them know on the House of Fusion mailing lists Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:329394 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
