SSRS: 2008 Updates

New features and updates to the latest version of Reporting Services. Here are just some of a few of my favorite improvements made to the 2008 release of SSRS. The most noticeable to me was the absence of the “Data” tab within the designer. Instead of having to click back and forth between tabs when…

SSRS: Report Header

Adding a graphic to the header of a report. Most reports require some sort of identifying header at the top of each page. While the header itself may be text, using a graphic provides a more polished look (though in my example I use a plain graphic). I’ll begin with the report created for the…

SSRS: Parameters

Providing control to the user to determine which records should be returned. As with most reports, reports might contain thousands of records, many of which the user doesn’t desire to view. To allow the user to decide upon a smaller subset of records, reports should be equipped with parameters commonly used with stored procedures. To…

SSRS: Nested Groups with Totals

Providing group totals within nested groups. Often a need arises with reports to group data. Grouping data provides the user with the ability to see records grouped based on shared values for certain fields, “Product Name” for example. As helpful as grouping may be, most people will need metrics to go along with those grouped…