Register Now!
Save $200
Register before October 17th to SAVE! ... and also receive a FREE copy of the Best-Selling AJAX Book, a $119 Value!
Untitled Document
2008 East
Platinum Sponsor
Untitled Document
2008 East Gold Sponsors
Untitled Document
2008 East Exhibitors
Untitled Document
2008 East Media Sponsors
Untitled Document
2008 Association Sponsor
2007 West Sponsors Conference Directory
2007 East Sponsors
Untitled Document
2008 SYS-CON Events

Can't Miss RSS Feed
Subscribe to the RSS Feed & Get All The Conference News As It Happens!

2008: Decision Year for RIAs - October 20-22, 2008 San Jose

Book Review: Microsoft SQL Server 2012 Reporting Services
The Report Builder's Bible

Over the years I have been on quite a few projects and there have been very few if any that did not require some type of reporting. For a while that meant Crystal Reports, but when SQL Server Reporting Services (SSRS) hit the scene, Crystal Reports began to fade on Microsoft projects. That was especially true if I had my way. I was the first person to champion SSRS in state projects in Pennsylvania. That was quite a battle but well worth it!

SSRS is one of the best solutions to come out of Microsoft. I don't say that lightly. I have plenty of complaints about different Microsoft products, but none about SSRS. The extensibility model built into the architecture makes the product completely customizable through extension.

This book introduces the SSRS architecture, the report manager, the basics of databases and database queries, but every topic introduced supports the report builder role. This book is all about the report builder. The chapters are listed below.

Part I: Getting Started
Chapter 1. Let's Start at the Very Beginning
Chapter 2. Putting the Pieces in Place: Installing Reporting Services

Part II: Report Authoring
Chapter 3. DB 101: Database Basics
Chapter 4. A Visit to Emerald City: The Report Wizard
Chapter 5. Removing the Training Wheels: Building Basic Reports
Chapter 6. Graphic Expression: Using Charts, Images, and Gauges
Chapter 7. Geography Lesson: Using Maps and Spatial Data Types
Chapter 8. Kicking It Up a Notch: Intermediate Reporting
Chapter 9. Beyond Wow: Advanced Reporting

Part III: Reporting Serving
Chapter 10. How Did We Ever Manage Without You--The Report Manager
Chapter 11. Delivering the Goods: Report Delivery
Chapter 12. Teamwork: Integrating Reporting Services
Chapter 13. Well Begun: Best Practices

One thing that struck me as a little weird was there was no "What's new in SSRS 2012" section. That is no big deal as I usually skip those sections anyway, but some readers may be looking for it. One big change that was worth mentioning was no more Report Models. I didn't see that mentioned anywhere in the book.

Reports can be built using Visual Studio 2010, Visual Studio 2010 with the SQL Server Data Tools add-in, and Report Builder. The author does a great job showing how to use the different tools with each example when usage is different. This really helps you get familiar with the tools and in the end will help you choose which tool you would like to use.

There is no coverage of custom extensions. My review started by touting that that is my favorite part of the product, so I was disappointed to see nothing about it. Although I do believe the content of this book will take you to the maximum possible potential of creating and delivering reports with the out of the box functionality, I have had to write custom extensions on many projects in order to meet the client's requirements. It is a topic that I would like to see covered and have seen covered in other reporting services books. However, I am not going to ding the book for this because I know that 99.9% of the reporting services authors will never have to write a custom extension or even have to know they exist.

My favorite part of the book was the hands on approach the author takes to teach us the ins and outs of SSRS. The best way to read this book is with Visual Studio or Report Builder open. The author goes through tons of step by step tasks.

Another thing I really liked was the coverage of data visualization. One of the biggest business user requests I hear is for data visualization in the form of charts, images, and gauges. This book will teach you how to use all three. It also includes great coverage of maps and spatial data types.

One last thing I really like about this book is that the author does a great job of teaching the reader how to retrieve data. In the beginning of the book he does an excellent job explaining joins. Then throughout the book he advances the reader to some fairly complex queries using joins. After running through all the examples you'll know how to get to the data you want.

Like I said above this is a Report Builder's book. If you want to learn everything there is about building reports, this is the book to teach you. The best part though is that you do not have to have any experience. This book takes the beginner from databases 101 to beginning reports, through intermediate reports, to building advanced reports.

The downloadable code is well organized and very usable. The author includes a database and an OLAP database. Both come with instructions for installing and configuring. All the code works well and adds a lot of value to the book.

All in all if you are building SQL Server 2102 Reporting Services Reports, or if you are interested in learning how to, you owe it to yourself to get this book.

Microsoft SQL Server 2012 Reporting Services 4/E

About Tad Anderson
Tad Anderson has been doing Software Architecture for 18 years and Enterprise Architecture for the past few.

Latest AJAXWorld RIA Stories
DXWorldEXPO LLC announced today that Dez Blanchfield joined the faculty of CloudEXPO's "10-Year Anniversary Event" which will take place on November 11-13, 2018 in New York City. Dez is a strategic leader in business and digital transformation with 25 years of experience in the I...
The standardization of container runtimes and images has sparked the creation of an almost overwhelming number of new open source projects that build on and otherwise work with these specifications. Of course, there's Kubernetes, which orchestrates and manages collections of cont...
Digital Transformation: Preparing Cloud & IoT Security for the Age of Artificial Intelligence. As automation and artificial intelligence (AI) power solution development and delivery, many businesses need to build backend cloud capabilities. Well-poised organizations, marketing sm...
DXWorldEXPO LLC announced today that "Miami Blockchain Event by FinTechEXPO" has announced that its Call for Papers is now open. The two-day event will present 20 top Blockchain experts. All speaking inquiries which covers the following information can be submitted by email to in...
DXWorldEXPO | CloudEXPO are the world's most influential, independent events where Cloud Computing was coined and where technology buyers and vendors meet to experience and discuss the big picture of Digital Transformation and all of the strategies, tactics, and tools they need t...
Untitled Document

Call 201 802-3020 or Click Here to Save $200!

Register Today and
Save $200

Your registrations includes: Golden Pass Delegates will receive full conference access on October 20-22, 2008 including: Lunch and Coffee Breaks, Collectible Bag and Archives of all sessions on DVD. Includes access to all Conference Sessions including the Technical Sessions, Exhibits, Keynotes, Vendor Technology Presentations, and Power Panels.

Sponsorship Opportunities

AJAXWorld offers the undisputed best platform to position your company as a leading vendor in the fast-emerging marketplace for AJAX and Enterprise Web 2.0.

Please call

Who Should Attend?

 CTOs & VPs of Engineering
 Directors of Technology
 Sr. User Interface Architects
 Front-End Engineers
 VCs & Industry Analysts
 Directors of Business Development
 Software Engineers
 Senior Architects
 Application Programmers & Software Developers
 Project Managers
 Web Programmers & Designers
 Companies & Organizations that need to stay in
  front of the latest Web technology

AJAXWorld Security Bootcamp

Introducing at AJAXWorld RIA Conference 2008 West the world's first-ever full, one-day immersive "AJAX Security Bootcamp" - led by one of the world's foremost AJAX security experts and teachers, HP's Billy Hoffman.

View the full one-day schedule

AJAXWorld 2008 West - Tracks

Track 01: Enterprise RIAs
Track 02: Frameworks & Toolkits
Track 03: Web 2.0 & Mashups
Track 04: Hot Topics
Track 05: The Future of the Web
Track 06: iPhone Developer Summit

Brought To You By:

AJAXWorld Magazine is the pre-eminent independent vendor-neutral resource for the fastest growing new segment of the software business: entirely Web-based applications and experiences.

Download the Latest Issue!

AJAXWorld Webcasts


AJAXWorld Keynotes & Power Panels

2008 SYS-CON TV Keynotes: Can We Fix the Web? By Douglas Crockford - by Douglas Crockford
2008 SYS-CON TV Keynotes: 2008: The Year of the RIA - by Anthony Franco
2008 SYS-CON TV Power Panel: The Business Value of RIAs
2008 SYS-CON TV Power Panel: What Lies Beyond AJAX
2007 SYS-CON TV Keynotes: Why Web 2.0 for the Enterprise Is Far More Than Just a Facelift - by Ted Farrell
2007 SYS-CON TV Keynotes: Fueling the Next Generation Web: A Peek Behind the Green Curtain - by Bob Brewin
2007 SYS-CON TV Keynotes: AJAX in the Balance - by Joe Stagner

AJAXWorld Sessions on SYS-CON.TV

· Bill Scott - Yahoo! UI Library
· David Heinemeier Hansson - AJAX on Rails
· Jesse James Garrett - Elements of User Experience
· Dion Hinchcliffe - Real World AJAX
· Eric Miraglia - Open Source AJAX Development
· Paul Rademacher - Mashing Up Your Web Application
· Adam Sah - Google Gadgets
· Doug Crockford - An Introduction to JavaScript
· David Linthicum - Enterprise Web 2.0
· Patrick Grady - The Imagination & Experience Web

AJAXWorld...All The AJAX Rock Stars in One Spot!

Past Events Archive

SOAWorld Conference & Expo 2008 East
Virtualization Conference & Expo 2008 East
AJAXWorld 2008 Conference & Expo East
SOAWorld Conference & Expo 2007 West
Virtualization Conference & Expo 2007 West
AJAXWorld 2007 Conference & Expo West
SOAWorld Conference & Expo 2007 East
Virtualization Conference & Expo 2007 East
AJAXWorld 2007 Conference & Expo East
Other SYS-CON Events

Join Over 10,000 Early AJAX Adopters
Who Have Attended AJAXWorld
• A&R Edelman
• Academic Enterprise
• Accoona Corp [2 delegates]
• Acxiom
• Adams Capital Management
• Adaptive Edge
• Adaptive Path
• Adobe Systems Incorporated [21 delegates]
• Adobe Systems Romania
• Ajax13
• All Risks, Ltd.
• alliance
• Alliance For Community Care
• AlphaDetail Inc
• Altera Corporation
• [6 delegates]
• Appeon Corporation [2 delegates]
• Apple Computer [5 delegates]
• Apress [3 delegates]
• Arkivio
• Astute Solutions
• Avaya Inc [2 delegates]
• Avenda Systems
• Avenue A | Razorfish [3 delegates]
• Axcella, LLC [2 delegates]
• Aximsoft
• Azimyth
• Backbase USA Inc. [4 delegates]
• BAE Systems [2 delegates]
• Bank of America [2 delegates]
• Barkley Evergreen & Partners Interactive
• Bayview Financial [2 delegates]
• BEA Systems [3 delegates]
• Billeo
• BMC Software, Inc. [2 delegates]
• Borland Software Corporation
• Bradford Technologies, Inc [2 delegates]
• Brilliance
• Brocade Communications Systems, Inc. [2 delegates]
• Brookside Capital LLC
• Brulant
• Bungee Labs, Inc [6 delegates]
• Bureau of Labor Statistics
• BUZ Interactive
• Cadena Software
• Calix Networks
• Callidus Software [2 delegates]
• Cambia Security
• Carnegie Mellon West
• Cautella, Inc.
• Celequest [3 delegates]
• Change Vision, Inc.
• Charles E. Kenney, CPA
• Charles Schwab & Co., Inc. [8 delegates]



.NET Developer's Journal - .NETDJ   |   ColdFusion Developer's Journal - CFDJ   |   Eclipse Developer's Journal - EDJ   |   Enterprise Open Source Magazine - EOS
Open Web Developer's Journal - OPEN WEB   |   iPhone Developer's Journal - iPHONE   |   Virtualization - Virtualization   |   Java Developer's Journal - JDJ   |
PowerBuilder Developer's Journal - PBDJ   |   SEO / SEM Journal - SJ   |   SOAWorld Magazine - SOAWM   |   IT Solutions Guide - ITSG   |   Symbian Developer's Journal - SDJ
WebLogic Developer's Journal - WLDJ   |   WebSphere Journal - WJ   |   Wireless Business & Technology - WBT   |   XML-Journal - XMLJ   |   Internet Video - iTV
Flex Developer's Journal - Flex   |   AJAXWorld Magazine - AWM   |   Silverlight Developer's Journal - SLDJ   |   |   Web 2.0 Journal - WEB2

SYS-CON EVENTS  |  AJAXWorld Conference & Expo  |  iPhone Developer Summit  |  OpenWeb Developer Summit  |  SOA World Conference & Expo  |  Virtualization Conference & Expo
INTERNATIONAL SITES:   India  |  U.K.  |  Canada  |  Germany  |  France  |  Australia  |  Italy  |  Spain  |  Netherlands  |  Brazil  |  Belgium
 Terms of Use & Our Privacy Statement     About Newsfeeds / Video Feeds
Copyright ©1994-2008 SYS-CON Publications, Inc. All Rights Reserved. All marks are trademarks of SYS-CON Media.
Reproduction in whole or in part in any form or medium without express written permission of SYS-CON Publications, Inc. is prohibited.