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. ~| Find out how CFTicket can increase your company's customer support efficiency by 100% http://www.houseoffusion.com/banners/view.cfm?bannerid=49 Message: http://www.houseoffusion.com/lists.cfm/link=i:4:202758 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic cfoutput groups
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:202775 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
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:202780 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=11502.10531.4 Donations Support: http://www.houseoffusion.com/tiny.cfm/54
RE: Dynamic cfoutput groups
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
RE: Dynamic cfoutput groups
I'll take a look at that article. Thanks. As for the query, there isn't just one. This is more of a dynamic reporting application where queries are entered, fields defined and a nice shiny report is spit out. The performance of the query is independent of the application (at least for my current goal). I was hoping that by using the cfoutput grouping, I would gain a small performance boost over manual grouping. This is unlikely, but I figured I'd give it a shot anyway. Thanks again, Chris [EMAIL PROTECTED] 04/14/05 10:35AM 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:202796 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