Project Report
Creating, Editing, and Managing Report Models for Reporting Services
SQL Server Technical Article
Published: January 2006
Applies To: Microsoft® SQL Server™ 2005 Reporting Services
Summary: This paper provides information about managing and editing report models with Microsoft SQL Server Reporting Services.
Introduction
Microsoft® SQL Server™ Reporting Services (SSRS), a component of Microsoft SQL Server, is a comprehensive, server-based platform that enables the creation, management, and delivery of traditional paper-oriented reports, interactive Web-based reports, end-user ad hoc reports, and embedded reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server® 2003 with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.
In SQL Server 2005, Reporting Services includes a new ad hoc reporting tool called Report Builder that information workers can use to create their own reports and explore business data. Report Builder uses report models, which provide a user-friendly view of the business data and enables users to build reports without deep technical understanding of the underlying data sources.
Report Builder and Report Model Overview
Enterprise reporting solutions are managed in much the same way as any typical IT project and usually focus on the functionality and report types that are predictable and add strategic value to the business.
Ad hoc report authoring is a complex task that does not fit a traditional business profile. Information workers know what information they need and how their report should look, but they usually don’t have the technical skills necessary to create a rich report design, to understand real-world database schemas, or to use formal query languages such as SQL and MDX. In
SQL Server Technical Article
Published: January 2006
Applies To: Microsoft® SQL Server™ 2005 Reporting Services
Summary: This paper provides information about managing and editing report models with Microsoft SQL Server Reporting Services.
Introduction
Microsoft® SQL Server™ Reporting Services (SSRS), a component of Microsoft SQL Server, is a comprehensive, server-based platform that enables the creation, management, and delivery of traditional paper-oriented reports, interactive Web-based reports, end-user ad hoc reports, and embedded reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server® 2003 with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions.
In SQL Server 2005, Reporting Services includes a new ad hoc reporting tool called Report Builder that information workers can use to create their own reports and explore business data. Report Builder uses report models, which provide a user-friendly view of the business data and enables users to build reports without deep technical understanding of the underlying data sources.
Report Builder and Report Model Overview
Enterprise reporting solutions are managed in much the same way as any typical IT project and usually focus on the functionality and report types that are predictable and add strategic value to the business.
Ad hoc report authoring is a complex task that does not fit a traditional business profile. Information workers know what information they need and how their report should look, but they usually don’t have the technical skills necessary to create a rich report design, to understand real-world database schemas, or to use formal query languages such as SQL and MDX. In