Report Portal

Build Ad hoc Reporting Solutions with Microsoft SQL Server 2005 Report Builder and Analysis Services

This paper introduces 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 SQL Server 2005 Analysis Services OLAP. We also highlighted a few product limitations as well as enterprise considerations. It is based on a real world implementation by Microsoft Business Intelligence Center of Excellence.


Designing an Analysis Services OLAP Cube
Building a Report Model
Deploying a Report Model to a Report Server
Authoring Ad-hoc Reports Using Report Builder
Publishing Reports
More Information


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.


Tags: ssrs, paper


2007-2015 VidasSoft Systems Inc.