Skip to main content

Professional SQL Server 2005 Reporting Services

Professional SQL Server 2005 Reporting Services

Paul Turley, Todd Bryant, James Counihan, Dave DuVarney

ISBN: 978-0-470-03918-2

Mar 2006

688 pages

Select type: E-Book

Product not available for purchase


SQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET.

Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.

What you will learn from this book

  • Details of programming reports and report scripting
  • Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content
  • High-level strategies for business and support systems
  • Rendering reports using .NET code, .NET IO namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options
  • How to design reports for mobile services
  • Various tools used to define data sources and semantic metadata models
  • How to use parameters and expressions to define creative report solutions
  • Advanced object-oriented programming techniques, with examples in C# and VB 2005.

Who this book is for

This book is for report designers, developers, administrators, and business professionals interested in learning the advanced functionality, report server administration, and security issues of SQL Server 2005 Reporting Services.

Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.


Foreword I.

Foreword II.


Part One: Getting Started.

Chapter 1: What Can You Do with Reporting Services?

Chapter 2: Introduction to Microsoft SQL Server Reporting Services 2005.

Chapter 3: Reporting Services Architecture.

Part Two: Report Design.

Chapter 4: Basic Report Design.

Chapter 5: Designing Data Access.

Chapter 6: Advanced Report Design.

Chapter 7: Report Solution Patterns and Recipes.

Part Three: Enabling End User Reporting with Report Builder.

Chapter 8: Reporting Services Report Models.

Chapter 9: Report Builder.

Part Four: Administering Reporting Services.

Chapter 10: Report Management.

Chapter 11: Report Server Administration.

Part Five: Reporting Services Integration and the Reporting Services Web Services.

Chapter 12: Integrating Reporting Services into Custom Applications.

Chapter 13: Extending Reporting Services.

Appendix A:Migrating Access Reports.

Appendix B: Reporting Services Object Model.

Appendix C: Transact SQL Command Syntax Reference.

Appendix D: Transact SQL System Variables and Functions.


Download Files for Chapter 12 Download
Download Files for Chapter 09 Download
Download Files for Chapters 04-14 Download
Missing Sample Code for Chapter 10, SampleDeployment.rss Download
Download Files for Chapter 13 Download
Download Files for Chapter 10 Download
Download Files for Chapter 05 Download
Download Files for Chapter 07 Download
Download Files for Chapter 04 Download
Download Files for Chapter 06 Download
Download Content,The content for this title has been posted and may be accessed via,descCd-download_code.html 3/22/06
9Error in Punctuation,Third line under User-Designed Reports section:
display, print. or save to a file.

Should be:
display, print, or save to a file.
15Error in Text,under Portal Integration section:

should be:
31-32Error in Text,On page 31 - 32 there is a table called Report Server. This table is missing check marks in certain columns. In the book on page 31, it says the table can be found at:
which redirects you to:

At this URL you can find the table in the book and it shows you what check marks are missing from the table.
347Error in Text,On the Delivery paragraph, text reads:
Push delivery on the other hand...

Should read:
Pull delivery on the other hand...
50Error in Reference,source

should be:
62Error in Code name,Configuration

should be:
64Error in Code name,ReportServer

should be:

should be:
482Error in Text,The SubCategory field should be added to the Group box. All other fields are added to the Details box.05/08/2006
4114Error in Text,Currency example reads:

Should read:
118Error in Figure 4-58,Figure 4-58 is incorrect. In both rows with the UK Locale:

should be:
134Error in Code,The last line on the page shows parameter name @ListPriceMax.

Should match Figure 5-11 that shows the parameter name to be @MaxListPrice.
139Error in Code,The CountryRegion table should be prefixed with the Person Schema to read Person.CountryRegion in the FROM clause.

The code had not been updated correctly from the earlier version of the AdventureWorks sample database before SQL Server 2005 schema references were required.
141Error In text,Text under Figure 5-18

The CountryCode parameter...

Should be

The CountryRegionCode parameter...
5143Error in Text,The text below figure 5-21:

as shown in Figure 5-22

Should be

as shown in Figure 5-21
150Error in Figure,Figure 5-30: CREATE PROCEDURE dbo.Get_StoresByLocation should be: CREATE PROCEDURE sp.GetStoresByLocation. 05/23/07
153Correction, In Figure 5-33, I found the example worked only if the CInt function was used in the Value column and NOT in the Expression column. Also, the text just above the figure needs to be corrected to correspond with the correction to the figure. 12/20/2007

should be:
6213Error in Text,Text reads:
In the Advanced Textbox Properties dialog box

Should read:
In the Navigation tab of the Textbox Properties dialog…
6233Error in Text,Text reads:
the trend increases back to front

Should read:
the trend decreases back to front or the trend increases front to back
12492Error in Text,At the bottom of page, the text reads:
URL for accessing your Customer Product Sales Pivot report

Should read:
URL for accessing your Customer Product List by Category report
12496Error in Text,At the bottom of page, the text reads:
the Customer Product Sales Pivot report

Should read:
the Customer Product List by Category report
503Error in Text,The WebReference:


Should be

Appendix C624Error in Code, Compute by paragraph is repeating information from Order By paragraph.

The corrected code should read:
SELECT ProductID, SalesOrderID, OrderQty
FROM SalesOrderDetail
ORDER BY ProductID, SalesOrderID
Appendix D639Error in Text,'ID should read:
Appendix D652Error in Text,Text reads:

Should read: