5.1. Riding Down Familiar Roads

We cover some familiar territory as we begin building reports without the Report Wizard. In Chapter 4, you used the Report Wizard to create table reports (the Customer List Report and the Customer-Invoice Report) and matrix reports (the Invoice-Batch Number Report). We create these types of reports once more but, this time, without the aid of the wizard.

Again, we look at the business needs of Galactic Delivery Services (GDS) and create reports to satisfy those business needs.

5.1.1. The Transport List Report

Features Highlighted

  • Building a GROUP BY clause using the Graphical Query Designer

  • Creating a table report from scratch

Business Need The transport maintenance department at Galactic Delivery Services needs ...

Get Microsoft SQL Server 2005 Reporting Services, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.