Print this page Share

Professional Microsoft SQL Server 2008 Reporting Services

ISBN: 978-0-470-24201-8
816 pages
December 2008
Professional Microsoft SQL Server 2008 Reporting Services (0470242019) cover image


  • Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions
  • Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
  • Includes programming examples focused on specific, scenario-based solutions
  • Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques
See More

Table of Contents



Part I: Getting Started.

Chapter 1: Introducing Reporting Services.

Chapter 2: Business Intelligence Solutions.

Chapter 3: Reporting Services Installation.

Chapter 4: Reporting Services Architecture.

Part II: Report Design.

Chapter 5: Basic Report Design.

Chapter 6: Report Layout and Formatting.

Chapter 7: Designing Data Access.

Chapter 8: Advanced Report Design.

Part III: Business Intelligence Reporting.

Chapter 9: Reporting with Analysis Services.

Chapter 10: Report Solution Patterns and Recipes.

Part IV: Enabling End-User Reporting with Report Builder 1.0.

Chapter 11: Report Models.

Chapter 12: Report Builder 1.0.

Part V: Administering Reporting Services.

Chapter 13: Content Management.

Chapter 14: Report Server Administration.

Part VI: Reporting Services Integration and Custom Programming.

Chapter 15: Integrating Reports into Custom Applications.

Chapter 16: Integrating Reports with SharePoint.

Chapter 17: Extending Reporting Services.

Appendix A: RDL Object Model.

Appendix B: T - SQL Command Syntax Reference.

Appendix C: T - SQL System Variables and Functions.

Appendix D: MDX Reference.


See More

Author Information

Paul Turley (Vancouver, WA) is a Manager of Specialized Services for Hitachi Consulting Education Services. Paul manages the Business Intelligence training team and teaches classes for companies throughout the world on Microsoft SQL Server technologies. He works with companies to design architecture for and build BI and reporting solutions. He has been developing business database solutions since 1991 for companies like Microsoft, Disney, Nike, and Hewlett - Packard. He has been a Microsoft Certified Trainer since 1996 and holds several industry certifications, including MCTS and MCITP for BI, MCSD, MCDBA, MSF Practitioner, and IT Project+.
Paul has authored and coauthored several books and courses on database, business intelligence, and application development technologies. He is the lead courseware developer for the Hitachi Consulting courses: “ SQL Server 2008 Business Intelligence Solutions ” and “ SQL Server 2008 Reporting Services Solutions. ” His books include Professional SQL Server 2005 Reporting Services , Professional SQL Server Reporting Services (SQL Server 2000) , Beginning Transact - SQL with SQL Server 2000 and 2005 , Beginning SQL Server 2005 Administration , Beginning Access 2002 VBA , Data Warehousing with SQL Server 2000 Analysis Services , and Professional Access 2000 Programming — all from Wrox. He is also a contributing author to SQL Server 2005 Integration Services Step by Step from Microsoft Press.

Thiago Silva (Dallas, TX) is a Manager of Specialized Services for Hitachi Consulting. Thiago has also been designing and developing custom .NET, business intelligence, and Reporting Services solutions since the early days of .NET and SQL Server 2000. He is a part of the Microsoft Strategic Alliance leadership group within Hitachi Consulting, where he helps create, manage, and deliver internal training materials and intellectual capital around the Microsoft technology stack. He also teaches the SQL Server Reporting Services course offered by Hitachi Consulting.
Thiago has been a featured guest on the talk show podcast .NET Rocks and is an active member of the .NET development community, frequently writing on his blog Silvaware, at http://silvaware.blogspot.com. Thiago holds a Bachelor of Business Administration degree in Management Information Systems from Texas A & M University, and a MCAD.NET technical certification.

Bryan C. Smith (Irving, TX) is a Manager of Specialized Services for Hitachi Consulting. Bryan has been developing and administering database solutions since 1997 for clients in a variety of industries. These days, he focuses on helping clients build Business Intelligence solutions using the Microsoft SQL Server product suite. Bryan holds MCITP, MCTS, MCDBA, A+, Network+, and Server+ certifications, and serves as an instructor for Hitachi Consulting ’ s SQL Server Analysis Services course.

Ken Withee (Seattle, WA) is a Senior Consultant with Hitachi Consulting. He earned a Master of Science degree in Computer Science studying under Dr. Edward Lank at San Francisco State University. Their work has been published in the LNCS journals and was the focus of a presentation at the IASTED conference in Phoenix. Their work has also been presented at various other Human Computer Interaction conferences throughout the world.
Ken has more than 7 years of professional computer and management experience working with a vast range of technologies.
Ken is a Microsoft Certified Technology Specialist and is certified with Microsoft Office SharePoint Server 2007 and SQL Server 2005, and has passed the certification exam for .NET 2.0.

See More


Download TitleSizeDownload
Read Me File 2.04 KB Click to Download
Thierry D'hers Foreword, Group Program Manager, SQL Server Reporting Services, Microsoft 97.08 KB Click to Download
Code from Book 4.24 MB Click to Download
Chapter 6 Errata 346.00 KB Click to Download
See More


Do you think you've discovered an error in this book? Please check the list of errata below to see if we've already addressed the error. If not, please submit the error via our Errata Form. We will attempt to verify your error; if you're right, we will post a correction below.

ChapterPageDetailsDatePrint Run
137 Error in Code
The T-SQL script should be corrected so this line reads:

ON F.SalesTerritoryKey = ST.SalesTerritoryKey
141 Error in Text
In order to reproduce the results shown in Chapter 6, one correction and additional step is necessary:

On page 141 - Group the details on the SalesTerritoryRegion field

After adding the CalendarYear and SalesTerritory Region groups shown on page 140, it is neccesary to add a detail row group expression for the SalesTerritoryRegion field. To do this, click the down arrow on the (DetailsGroup) in the Row Groups list and choose Group Properties. In the Group Properties dialog, click the Add button under Group expressions. Choose the [SalesTerritoryRegion] from the field list and then click OK to close the dialog. After making this modification to the detail group, hover over the SalesAmount field and click the field list icon. Reselect the SalesAmount field from the drop-down list. This will apply the SUM aggregate function
144 Error in Text
Instead of inserting the total row for the SalesTerritoryRegion field (shown in Figure 6-19,) right-click the CalendarYear textbox and then follow the same instructions to insert a new row for the total.
572, 573 Error in Text
On page 572, the function declaration in the C# code uses the wrong function name. It is:


It should be:


On Pg 573, just below the VB code sample, there’s a reference to the same function name in the paragraph, but it’s misspelled: REGetParemeter (it’s not pluralized like the code).
See More

Related Titles

Back to Top