Pro SQL Server 2012 Reporting Services, Third Edition

C H A P T E R  13

Creating Reports Using Report Builder 1.0, 2.0, and 3.0

When it comes to user-developed reports, we often have to deal with the problem of providing the underlying data in a controlled and secure way, but with enough freedom for that data to be useful for making business decisions. In SQL Server 2005, Reporting Services included the first version of the Report Builder. Report Builder is an application that offloads some of the tedious report design tasks to the report consumers themselves.

In Report Builder 1.0, users with appropriate permissions could create and publish their own reports with one caveat: the data had to be provided using a predesigned report model. This report model created an abstraction layer, if you will, ...