Subscribe to our e-mail newsletters
For more info on a specific newsletter, click the title. Details will be displayed in a new window.
Computerworld Daily News (First Look and Wrap-Up)
Computerworld Blogs Newsletter
The Weekly Top 10
More E-Mail Newsletters 
Computerworld 2007Subscribe to Computerworld
40 years of the most authoritative source of news and information for IT leaders.

Reporting Tools Added to SQL Server

 

Sign up to receive Security Resource Alerts

February 02, 2004 (IDG News Service) -- Microsoft Corp. last week shipped software that adds reporting capabilities to SQL Server 2000, rounding out the line of business intelligence tools the company integrates with its relational database.

SQL Server 2000 Reporting Services has been available for beta testing since October. One of the testers was The Long & Foster Cos., a Fairfax, Va.-based real estate services firm that wants to standardize on the technology to deliver nearly 300 corporate reports to its 13,000 employees.


Lance Morimoto, senior manager of e-commerce and application development at Long & Foster, said it now uses a mishmash of reporting tools from vendors like Cognos Inc. and Crystal Decisions Inc., which was acquired by Business Objects SA in December. Long & Foster has completed a pilot program involving 35 reports and is happy with the Reporting Services software so far, he said.


The company created the 35 reports with Microsoft's new Report Writer authoring tool, which is offered as an add-on to the vendor's Visual Studio .Net development suite. "The whole solution is pretty tightly integrated with .Net," Morimoto noted.


But he added that it's too early to tell whether Report Writer will suffice for porting Long & Foster's 250 existing reports to Microsoft's technology. There may still be a need to use third-party software like Crystal Reports, he said.


Dan Zerfas, vice president of application development at First Premier Bank in Sioux Falls, S.D., said the version of Report Writer that was included with the second beta release of Reporting Services in November was much better than the initial test code. "It's like night and day," he said.


First Premier had been building reports using Microsoft's SQL Query Analyzer and Access database. Its developers were able to virtually cut and paste the Access code into Reporting Services, which saved a lot of time, Zerfas said. They also liked the software's user interface, he added.


Philip Russom, an analyst at Forrester Research Inc., said he doesn't expect Microsoft's entry into the market to hurt reporting tools vendors too badly. Report Writer is a "Version 1" product that needs to mature, Russom said, adding that the success of Reporting Services depends partly on whether vendors such as Cognos and Business Objects agree to support Microsoft's Report Definition Language. That would let reports authored with third-party tools be managed and distributed through Microsoft's software.


Microsoft released Reporting Services 11 months after announcing its plan to add the technology . It originally planned to introduce the software with Yukon, a 64-bit upgrade of SQL Server. But the Yukon launch was delayed until later this year, prompting Microsoft to offer the reporting capabilities with SQL Server 2000.


Microsoft is now working on a Reporting Services upgrade that will ship with Yukon, said Thomas Rizzo, director of its SQL Server management team. That version will be able to more easily generate reports from online analytical processing databases, Rizzo said.


Niccolai writes for the IDG News Service.













Product Details





SQL Server 2000 Reporting Services




Lets users program their databases to generate reports and then helps manage and distribute the reports.


Can pull data from multiple sources, including Oracle and DB2 databases as well as SAP's business applications.


Exports reports directly to Excel spreadsheets or generates them in formats such as HTML, PDF and XML.


Reprinted with permission from

For more news from IDG visit IDG.net
Story copyright 2006 International Data Group. All rights reserved.


Print this Story Send Us Feedback E-mail this Story Digg! Digg this Story Slashdot this Story
Reporting Tools Added to SQL Server
"Apple yesterday dropped the price of the 64Gb MacBook Air by a whopping $500 ($400 less for the SSD and..." Read more...
"It's a cheaper IT Blogwatch: in which Apple cuts the price of the top-end MacBook Air. Not to mention dan..." Read more...
Read more Software posts or See all Blogs
Microsoft promises four patches next week
Google gives away home-cooked Web application security scanner
Expect iPhone, Fourth of July scams, security firm says
More top stories...
Microsoft trumpets security additions in upcoming IE8
Apple cuts price of high-end SSD MacBook Air by $500
Ultrathin showdown: Apple MacBook Air vs. Lenovo ThinkPad X300 vs. Toshiba Portege R500
All it takes is a couple hours and about $125 to breathe new life into an old laptop. Here's how.
Is Microsoft's Golden Age over? What are Gates' most memorable quotes? Find out in Computerworld's complete coverage of the end of the Bill Gates era at Microsoft.
There are some things your CIO definitely doesn't want to hear. Also don't miss the flipside, Five things you should always tell your boss.
With its latest version, Mozilla's browser continues to raise the bar for what Web browsers should be.
Reviews, analyses, how-tos, visual tours, hot issues and predictions about Microsoft's new OS.
Four years from now, the IT field will be a vastly different place. Will you be ready?
All Zones
Application Performance Zone
Business Continuity Zone
Data Center Management Zone
Enterprise-Class Security Zone
The File Data Management Zone
Grid Computing on Windows Zone
Security Management Zone
ITIL Best Practices Zone
The SAS Zone
Storage Virtualization Zone
Business Intelligence and Analytics Zone

Ads by TechWords

See your link here
Computerworld Technology Briefing: An open-source path to optimal virtualization
Download this Technology Briefing now!
(Source: Novell/IBM/Intel) Virtualization is about a lot more than just lowering total cost of ownership. In fact users that have taken an open source path to virtualization have realized the additional, mission-critical benefit of markedly reduced IT complexity, as well as a more flexible infrastructure that is easier to change to meet shifting, often unpredictable business requirements.
Download this executive briefing download
Advance your BlackBerry(R) solution management know-how this July
Advance your BlackBerry(R) solution management know-how this July
BlackBerry Technical Seminar, register today!
Go to the webcast 
Rapid application development, rapid results
Download this special report now!
(Source: Intersystems) All too many businesses suffer from IT infrastructures that are a hodge-podge of disconnected databases and applications. What's needed is the ability rapidly develop connected applications under a unified service-oriented architecture. InterSystems Ensemble integration environment and Cache database are effective tools in answering this need, delivering a rapid ROI.
Download this white paper go
White Papers
Read up on the latest ideas and technologies from companies that sell hardware, software and services.
Deploying Virtualized NetWare on Linux Whitepaper
Toward More Flexible, Next-Generation Collaboration Solutions
Driving Business Success Through Workgroup Choice and Flexibility
View more whitepapers