Sql Server 2005 Report Builder 2.0
Tian Ying He, Carolyn Chau Microsoft Corporation October 2006 Applies to: Microsoft.NET Framework 2.0 Microsoft SQL Server 2005 Reporting Services Microsoft SQL Server 2005 Analysis Services Summary: This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few product limitations, as well as enterprise considerations.
I have heard that there is a new version of Report Builder in SQL Server 2008. Can you provide some details and examples? What is new with Report Builder 2.0?
It is based on a real-world implementation by Microsoft Business Intelligence Center of Excellence. (14 printed pages) Click here to download the Word version of this article,. Contents Introduction Many organizations have adopted Microsoft SQL Server Reporting Services and Analysis Services OLAP as part of their business-intelligence platform. SQL Server 2005 Reporting Services introduces a new end-user product, Report Builder, that enables business users to create ad-hoc reports based on information stored in both relational and OLAP data stores. Report Builder Overview SQL Server 2005 Report Builder is a ClickOnce application developed using the Microsoft.NET Framework version 2.0 and Windows Forms technology. Install Game Xbox 360 Hard Drive. It is included in SQL Server 2005 Enterprise, Standard, and Workgroup editions. With Report Builder, business users can create their own reports without having to understand the underlying database schema, Transact-SQL or MDX query syntax, or developer tools such as Microsoft Visual Studio.
Report Builder comes with templates for table, matrix, and chart reports. Ad-hoc reports can be created by selecting a report-layout template and dragging data fields to a report-design area.