CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0Figure 13-43. Report Builder 1.0 reports published in Report Manager
Creating Reports with the Report Builder 2.0 Wizard
At this point, we created SSRS reports with BIDS and Report Builder 1.0 using ClickOnce. Both design
environments provide different levels of control over report design. While BIDS offers report creators
much more flexibility than Report Builder 1.0, it might not be the best choice for people who are not also
application programmers. Report Builder 1.0, by contrast, is easy to learn and to use to publish reports;
however, it comes with limitations in that reports can only be created using prebuilt models, which is
not enough to meet everyone’s needs. In SSRS 2008, Microsoft provided Report Builder 2.0, which
supported true ad hoc query and report design not solely based on report models. Report Builder 2.0’s
modern look and feel, with Ribbon technology like that found in Office 2007 applications, gave report
creators a familiar environment to work in.
Figure 13-44 shows the Report Builder 2.0 interface. Microsoft’s use of the new Ribbon technology is
apparent in the figure.