Brad, The question here is why do you feel that ColdFusion needs to do the reporting? Is the data set ideal for CF?
In the server farm that I work with, we have dozens upon dozens of database and multiple data warehouses. We use the report builder for SQL Server 2000 and it is quick and gets the reports to those who need it. The SQL Server reports also have an option to deploy the calculated report to an HTML page, which is a static result of the finished compilation. Now, don't get me wrong here. I have used CF for 8 years and use it for the majority of my solutions, but it is not meant to report everything. You have to think about CF connecting to the servers you want to run reports on as additional network overhead. You can create static reports in CF as well and can offer lots of pretty graphing options. You can go as far as building a Flex Charting solution as well for even better results. I would recommend Flex Charts over CF Reports for more options and flexibility. Now, who is going to build these reports? Are they asking you to create the reports or the DBAs? Is job security a concern? Just be objective here and figure out what is the best option instead of asking if CF should get the oppurtunity. From what I have seen on the calculations for some of the larger reports, the SQL report builder is quicker on the recompilation of a report. CF is quicker when rendering aggregated data sets that do not need to recompile the data sets. Teddy On 10/3/06, Brad Wood <[EMAIL PROTECTED]> wrote: > > I'm looking for opinions advice here. My DBA is going nuts over the SQL > Server 2005 reporting services. He wants to replace our current custom > built (CF) reporting mechanism with it. I think ColdFusion report > builder would be a better option since we are, after all, a ColdFusion > shop, not .NET. And not to mention all of our production servers run > Linux. > > > > Nice features our company seems to want often in reports is the ability > to sort and filter data, add/remove/re-arrange columns from the report. > Keep stats on when the report was last run, by whom, and how long it > took. Change the server the report runs off of on the fly. > > > > The problem I have is that I know nothing about the SQL Server 2005 > reporting service, OR the ColdFusion report builder other than they are > all free. > > A couple of the guys on the database team are already playing around > with the SQL version and making a collection of cool reports to use in > their argument for why we should use it. Before all the pointy-haired > bosses get sold on that I want to make sure ColdFusion report builder > gets its fair say. > > > > Can anyone with experience with one or the other comment on the > following: > > > > Which one is faster? > > Which one is better? > > Which one has more features when it comes to manipulating the data after > running the report? > > Which one will get my morning coffee and bagel for me? > > Which one has the easiest learning curve? > > > > I anxiously await advice. > > > > Thanks! > > > > ~Brad > > > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Introducing the Fusion Authority Quarterly Update. 80 pages of hard-hitting, up-to-date ColdFusion information by your peers, delivered to your door four times a year. http://www.fusionauthority.com/quarterly Archive: http://www.houseoffusion.com/groups/CF-Talk/message.cfm/messageid:255223 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.4
