CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-19. SSRS Report Builder role
Note To manage roles in SQL Server Reporting Services 2008 R2, we have to connect to the Reporting
Services instance by running SQL Server Management Studio as an administrator. For more details on connecting
to the Reporting Services instance and roles, please see the “Introducing SSRS Roles” section in Chapter 11.
Creating Reports with Report Builder 1.0
To this point you have created all the requisite pieces for using Report Builder 1.0—you have created the
report model Patient Census and deployed it to the report server. It is now waiting to be used as a source
for the front-end Report Builder 1.0 application. Report Builder 1.0 provides some of the same
functionality of a report development environment, such as BIDS or Visual Studio, including the ability
to drag and drop data elements to the design area with Matrix, Table, and Chart data regions as well as
the ability to deploy finished reports to the report server. However, before you dive in, we should state
that Report Builder 1.0 serves the purpose of allowing end users to design their own reports. It was
designed to be intuitive and friendly, and because it is not a full-featured IDE, it may at first seem
limited.
In this section, you will explore Report Builder 1.0 and uncover the features that are available to the
report designer such as adding functions, similar to adding expressions in BIDS, and providing filtering,