CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0
Summary
Ad hoc reporting gives users the ability to create their own reports on the fly. It has always been a highly
requested feature for any reporting platform and Reporting Services has been no different. As shown in
this chapter, Microsoft decided to deliver their first incarnation of ad hoc reporting in the form of Report
Builder 1.0. They significantly enhanced the user experience in the Report Builder 2.0 to allow reporting
data from relational data and OLAP data sources as well. With the SQL Server 2008 R2 release, came
Microsoft’s most recent version, Report Builder 3.0. Furthermore, we showed you an amazing feature
called Report Parts that allow report authors to reuse existing sections of reports, saving them hours or
potentially days in report development time. In this chapter, you learned about some of their respective
benefits and some of their limitations. You have probably come away with an answer to the question of
whether the Report Builder is a tool that your users will want. If the answer is “Yes,” as we hope it will be,
then the good news is that these are included as standard features.