You can use CF with OLAP. Read http://sys-con.com/story/?storyid=46790 for a decent jumping-off point.
But if you don't want to pursue OLAP (it's not exactly painless) there are several very capable members of this list who have helped me in the past with my ugly web-based reporting queries. If you post the query you may get some very useful tips on how to solve the performance problems at the root... -----Original Message----- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 8:35 AM To: CF-Talk Subject: RE: Dynamic cfoutput groups Thanks for the response. For the application requirements, this should remain a web-based CF reporting app. I would just like to use cfoutput to the do the display grouping rather than handling it manually. Any thoughts? Thanks, Chris >>> [EMAIL PROTECTED] 04/14/05 09:23AM >>> It sounds like you're after a kind of pivot table functionality... Do you have OLAP capabilities at your disposal? (MS Reporting Services is installed w/ SQL Server if that applies...) -----Original Message----- From: Chris Terrebonne [mailto:[EMAIL PROTECTED] Sent: Thursday, April 14, 2005 6:21 AM To: CF-Talk Subject: Dynamic cfoutput groups Morning everyone. I currently have a reporting app that allows output to be grouped dynamically based on user preference. The user can select an unlimited number of values to group on and the groups are nested accordingly. I wasn't able to figure out a way to performing the grouping using cfoutput's group attribute, so I just manually break out and track the groups. Now that this app is in production, I am finding a performance hit on very large record sets and I am again exploring cfoutput's grouping as an option. Does anyone have any experience using cfoutput to dynamically construct nested groups? Thanks, Chris This email and its attachments may contain confidential information which is intended only for the use of the person(s) named above. If you are not the intended recipient, you are hereby advised that any disclosure, copying, distribution or the taking of any action based on the contents of this information is prohibited. If you have received this transmission in error, please notify the sender and delete this email from your computer. Thank you. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Logware (www.logware.us): a new and convenient web-based time tracking application. Start tracking and documenting hours spent on a project or with a client with Logware today. Try it for free with a 15 day trial account. http://www.houseoffusion.com/banners/view.cfm?bannerid=67 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202793 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/4 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:4 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54