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

Description

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.

Acknowledgments.

Foreword I.

Foreword II.

Introduction.

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.

Index.

Download Files for Chapter 04
Code downloads for this title are available here.
Download
Download Files for Chapters 04-14
Download
Download Files for Chapter 05
Download
Download Files for Chapter 06
Download
Download Files for Chapter 07
Download
Download Files for Chapter 09
Download a .zip file containing the files from Chapter 09.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.
Download
Download Files for Chapter 10
Download a .zip file containing the files from Chapter 10.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.
Download
Download Files for Chapter 12
Download a .zip file containing the files from Chapter 12.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.
Download
Download Files for Chapter 13
Download a .zip file containing the files from Chapter 13.
To uncompress the file, Windows users can use Windows built-in ZIP utilities or a 3rd party utility like WinZip or WinRAR. Macintosh users can simply double-click the downloaded file to extract using the built-in archive utility.
Download
Missing Sample Code for Chapter 10, SampleDeployment.rss
Sample code for Chapter 10 has a file SampleDeployment.rss which is empty. Code attached
Download
ChapterPageDetailsDatePrint Run
Download Content
The content for this title has been posted and may be accessed via http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584979,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.
05/11/07

15Error in Text
under Portal Integration section:
Plumbtree

should be:
Plumtree
6/26/06

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:
http://www.microsoft.com/sql/2005/productinfo/rsfeatures.msqx
which redirects you to:
http://www.microsoft.com/sql/technologies/reporting/rsfeatures.mspx

At this URL you can find the table in the book and it shows you what check marks are missing from the table.
06/27/2006

347Error in Text
On the Delivery paragraph, text reads:
Push delivery on the other hand...

Should read:
Pull delivery on the other hand...
05/08/2006

50Error in Reference
source

should be:
processing
01/09/07

62Error in Code name
Configuration

should be:
ConfigurationInfo
01/09/07

64Error in Code name
ReportServer

should be:
ReportServerTempDB
01/09/07

64Typo
know

should be:
known
01/09/07

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:
$123,456,78.9.12

Should read:
$123,456,789.12
05/08/2006

118Error in Figure 4-58
Figure 4-58 is incorrect. In both rows with the UK Locale:
11/1/2003

should be:
1/11/2003
09/03/08

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.
07/13/2007

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.
09/03/08

141Error In text
Text under Figure 5-18

The CountryCode parameter...

Should be

The CountryRegionCode parameter...
4/6/09

5143Error in Text
The text below figure 5-21:

as shown in Figure 5-22

Should be

as shown in Figure 5-21
03/27/09

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

155Typo
hierarchal

should be:
hierarchical.
01/09/07

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

Should read:
In the Navigation tab of the Textbox Properties dialog…
05/08/2006

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
05/08/2006

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
05/08/2006

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
05/08/2006

503Error in Text
The WebReference:

reportservice

Should be

reportservice2005
03/11/09

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
COMPUTE SUM(OrderQty)
05/08/2006

Appendix D639Error in Text
'ID should read:
@@ID
05/08/2006

Appendix D652Error in Text
Text reads:
pwdconpare

Should read:
pwdcompare
05/08/2006