V.3.3. Designing, Publishing, and Maintaining Reports

Chapter 2 of this mini-book shows you how to create report models and publish them to the report server. You then use the Report Builder to create and publish a report to the report server.

In this section, you find out how to design, publish, and maintain reports by using the Report Designer within the Business Intelligence Development Studio (BIDS) and the stand-alone Report Builder 2.0.

The following two sections show you exactly how to create reports. You create a report by using the Report Designer in BIDS. You then create a similar report by using the Report Builder 2.0.

The steps in the following two sections assume you have AdventureWorks2008 installed on your SQL Server 2008 server. If you don't have it installed, review Book III, Chapter 5 for the steps.

V.3.3.1. Using the BIDS Report Designer

In the following steps, you create a matrix report used to analyze sales within the Adventure Works Company.

  1. Choose StartAll ProgramsMicrosoft SQL Server 2008SQL Server Business Intelligence Development Studio (BIDS).

    This launches ...

Get Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies® now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.