I believe the question being asked here is really: In a Linux based CF/Java environment with a SQL Server back end, would it be better to extend our current custom reporting solution in ColdFusion using CF Reports or is SQL 2005 Reporting Services the better option. If SQL 2005 Reporting Services are a better option, we could off load that functionality and purchase a couple of windows servers (we run all Linux now) and get .Net up and running for those sections. Then we run into questions as to integrating our current security model etc. But we could head down that road if the SQL solution is that much better than CF Report. We were hoping to tap into the collective consciousness of this list and come up with a better idea without months of research, case studies and prototypes.
If anyone has worked with either/both of these services and/or has an opinion for or against either, we'd appreciate your input. Thanks! Christine Davis ColdFusion Lead Nations Technical Services Prairie Village, KS 913-748-8044 ext 4703 [EMAIL PROTECTED] -----Original Message----- From: Teddy Payne [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 03, 2006 12:47 PM To: CF-Talk Subject: Re: reports reports reports 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:255224 Subscription: http://www.houseoffusion.com/groups/CF-Talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.4
