CHAPTER 13 CREATING REPORTS USING REPORT BUILDER 1.0, 2.0, AND 3.0selecting the second cell. Once you have selected it, right-click and then choose Add Totals. The total
fields are automatically added for you. You can emphasize the totals by making the two new total cells
bold. When complete, the report will appear as it does in Figure 13-60.
As you have seen, the new Report Builder 2.0 has many of the features of the full-blown design
environment in BIDS with only minor exceptions. One exception that stands out is the inability to check
a report directly into a version control application such as Team Foundation Server.. However, for its
intention, the Report Builder 2.0 does serve the purpose of putting a design environment in the hands of
people who can create reports beyond the constraint of report models, but who may not be VB .NET
developers per se. Making this valuable design tool available as part of SSRS was one more step forward
in bringing SSRS to the masses. In the next section, we will cover the enhancements made in the Report
Builder 3.0 application as well as walk through an example using the latest release of Microsoft’s
Reporting Services ad-hoc tool.
Figure 13-60. Report with final formatting