Skip to Content
Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®
book

Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

by Robert D. Schneider, Darril Gibson
September 2008
Beginner to intermediate
768 pages
17h 40m
English
For Dummies
Content preview from Microsoft® SQL Server™ 2008 All-In-One Desk Reference For Dummies®

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 ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.

Read now

Unlock full access

More than 5,000 organizations count on O’Reilly

AirBnbBlueOriginElectronic ArtsHomeDepotNasdaqRakutenTata Consultancy Services

QuotationMarkO’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.
Julian F.
Head of Cybersecurity
QuotationMarkI wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.
Addison B.
Field Engineer
QuotationMarkI’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.
Amir M.
Data Platform Tech Lead
QuotationMarkI'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Mark W.
Embedded Software Engineer

You might also like

Microsoft® SQL Server® 2008 Step by Step

Microsoft® SQL Server® 2008 Step by Step

Mike Hotek
Microsoft® SQL Server® 2008 Bible

Microsoft® SQL Server® 2008 Bible

Paul Nielsen, Mike White, Uttam Parui

Publisher Resources

ISBN: 9780470179543Purchase book