Don't use CFML, CFML sucks when it comes to reporting. No matter what anyone tries to tell you it is not an efficient choice for reports.
Try SQL Server reporting services, crystal reports or aspx is even better then CFML in this arena. -----Original Message----- From: Torrent Girl [mailto:[EMAIL PROTECTED] Sent: Thursday, September 11, 2008 6:54 PM To: SQL Subject: Large CF/SQL Reports Hello I have a question regarding running reports in SQL. I have to run fairly large reports and 99% of the time get a timeout error. I'd try to override the timeout with cfsetting and I also thought about change the setting in cf admin but I am not sure of what is a safe setting. Can anyone tell me the best way to run large reports? They can be made smaller as the requestor needs a lot of info. Any best pratcie tips will be appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Adobe® ColdFusion® 8 software 8 is the most important and dramatic release to date Get the Free Trial http://ad.doubleclick.net/clk;203748912;27390454;j Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:3131 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
