Skip to main content

Professional Microsoft SQL Server 2008 Reporting Services

Professional Microsoft SQL Server 2008 Reporting Services

Paul Turley, Thiago Silva, Bryan C. Smith, Ken Withee

ISBN: 978-1-118-05954-8

Jan 2011

816 pages

Select type: E-Book

Product not available for purchase


  • 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


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.


Read Me File
Thierry D'hers Foreword, Group Program Manager, SQL Server Reporting Services, Microsoft
Code from Book
Chapter 6 Errata
ChapterPageDetailsDatePrint Run
137Error in Code
The T-SQL script should be corrected so this line reads:

ON F.SalesTerritoryKey = ST.SalesTerritoryKey

141Error 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

144Error 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, 573Error 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).