Wiley
Wiley.com
Print this page Share

Professional SQL Server 2005 Reporting Services

ISBN: 978-0-7645-8497-8
720 pages
March 2006
Professional SQL Server 2005 Reporting Services (0764584979) cover image
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.

See More
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.

See More
Paul Turley is a senior consultant for Hitachi Consulting. He architects database, reporting and business intelligence solutions for many prominent consulting clients. In addition to Reporting Services, he has created reporting solutions using Crystal Reports, Active Reports, and Access. Since 1988, he has managed IT projects, designed and programmed applications using Visual Basic 3, 4, 5, 6, ASP.NET, ADO.NET, and SQL Server. He obtained his MCSD certification in 1996 and other certifications include MCDBA, IT Project+, and Microsoft Solutions Framework (MSF) Practitioner.
He designed and maintains www.Scout-Master.com, a web-based service that enables Boy Scout units to manage their membership and advancement records online using ASP.NET, SQL Server, and Reporting Services.
Paul authored Beginning Transact SQL for SQL Server 2000 and 2005. He has been a contributing author on books and articles including Professional Access 2000 Programming, Beginning Access 2002 VBA, and SQL Server Data Warehousing with Analysis Services, all from WROX Press.

Todd Bryant has been creating custom data-focused applications and reporting solutions since the early eighties. He began using Microsoft technologies in 1998, and the love affair began. Todd has been contract programming, teaching, and developing custom courseware ever since. He is currently working half-time as a software architect for SoftWyre, a Little Rock, Arkansas, based software development company as well as training half-time at Netdesk Corporation in Seattle, where he concentrates on enterprise solutions, Com+ services, and object-oriented programming using both VB.NET and C#. His certifications include the MCSD, MCSE, MCDBA, and MCT certifications from Microsoft; the CNA certification from Novell; and both CompTIA‚ ™s A+ and CTT+.

James Counihan started teaching himself binary in the early 1970s. He is now a Seattle-area consultant specializing in development on the .NET platform.

Dave DuVarney is a principal for Statera‚ ™s Seattle office. He has broad technical knowledge stemming from his experiences as a software developer, a certified public accountant, and a technology trainer. Dave has been involved in multiple software development projects ranging from contract management systems to human rights auditing. He is proficient in numerous development languages as well as Microsoft business intelligence technologies. Most recently he has been consulting and delivering on SQL Server 2005 Analysis Services, Reporting Services, and Integration Services. Dave is the coauthor of Professional SQL Server Reporting Services.

See More
Download TitleSizeDownload
Download Files for Chapters 04-14 968.71 KB Click to Download
Download Files for Chapter 04 129.86 KB Click to Download
Download Files for Chapter 05 124.12 KB Click to Download
Download Files for Chapter 06 129.12 KB Click to Download
Download Files for Chapter 07 457.28 KB Click to 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.
40.65 KB Click to 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.
7.29 KB Click to 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.
15.58 KB Click to 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.
138.61 KB Click to Download
Missing Sample Code for Chapter 10, SampleDeployment.rss
Sample code for Chapter 10 has a file SampleDeployment.rss which is empty. Code attached
4.69 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
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
9 Error 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
15 Error in Text
under Portal Integration section:
"Plumbtree"

should be:
"Plumtree"
6/26/06
31-32 Error 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
3 47 Error 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
50 Error in Reference
source

should be:
processing
01/09/07
62 Error in Code name
Configuration

should be:
ConfigurationInfo
01/09/07
64 Error in Code name
ReportServer

should be:
ReportServerTempDB
01/09/07
64 Typo
know

should be:
known
01/09/07
4 82 Error in Text
The SubCategory field should be added to the Group box. All other fields are added to the Details box.
05/08/2006
4 114 Error in Text
Currency example reads:
"$123,456,78.9.12"

Should read:
"$123,456,789.12"
05/08/2006
118 Error 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
134 Error 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
139 Error 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
141 Error In text
Text under Figure 5-18

"The CountryCode parameter..."

Should be

"The CountryRegionCode parameter..."
4/6/09
5 143 Error 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
150 Error in Figure
Figure 5-30: CREATE PROCEDURE dbo.Get_StoresByLocation should be: CREATE PROCEDURE sp.GetStoresByLocation.
05/23/07
153 Correction
"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
155 Typo
hierarchal

should be:
hierarchical.
01/09/07
6 213 Error 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
6 233 Error 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
12 492 Error 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
12 496 Error 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
503 Error in Text
The WebReference:

reportservice

Should be

reportservice2005
03/11/09
Appendix C 624 Error 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 D 639 Error in Text
'ID should read:
@@ID
05/08/2006
Appendix D 652 Error in Text
Text reads:
"pwdconpare"

Should read:
"pwdcompare"
05/08/2006
See More

Related Titles

Back to Top