Skip to Content
Professional Microsoft SQL Server 2012 Reporting Services
book

Professional Microsoft SQL Server 2012 Reporting Services

by Paul Turley, Robert M. Bruckner, Thiago Silva, Ken Withee, Grant Paisley
June 2012
Intermediate to advanced
912 pages
23h 35m
English
Wrox
Content preview from Professional Microsoft SQL Server 2012 Reporting Services

Chapter 4

Basic Report Design

What's in this chapter?

Understanding the basic building blocks of report design

How to design a report using the Matrix Wizard to learn the essential components

A tour of the Report Builder design tool

How to design a simple report using manual design steps to learn basic report structure

It's time to jump in and design a report! This chapter is designed to guide you through the steps necessary to design a basic report, first using the Matrix Wizard and then again using manual steps that will help you understand the components and design process a little at a time. The purpose of this first exercise is to demonstrate high-level report design without getting into the nuts and bolts of the process. We'll cover all the nuances and details later, but in this quick tour, you'll see how to create a simple report in a few easy steps.

What Good Are Wizards, Anyway?

I go back and forth on using the Report Wizard when I teach report design classes. I decided not to use it in this chapter, as I have in the past. The Report Wizard is handy if you want to throw together a quick report. If you know how to create a report manually, you'll be able to use the Report Wizard on your own, and you don't need me to hold your hand through the process. I figured that you probably didn't buy this book so that you could learn how to run a wizard, so I chose not to waste your time with this step. We will, however, use wizards to create a matrix data region.

In this quick tutorial, ...

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 2012 Reporting Services

Microsoft SQL Server 2012 Reporting Services

Stacia Misner
Professional Microsoft SQL Server 2014 Integration Services

Professional Microsoft SQL Server 2014 Integration Services

Brian Knight, Devin Knight, Jessica M. Moss, Mike Davis, Chris Rock

Publisher Resources

ISBN: 9781118237137Purchase book