Skip to main content

Professional SQL Server Reporting Services

Professional SQL Server Reporting Services

Paul Turley, Todd Bryant, James Counihan, George McKee, Dave DuVarney

ISBN: 978-0-764-56878-7

May 2004

624 pages

Select type: Paperback

Product not available for purchase


What is this book about?

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. 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 a revolutionary new tool.

What does this book cover?

Here are just some of the things you'll learn in this book:

  • Details of programming reports and report scripting
  • Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content
  • How to manage reports using Report Manager or program code
  • High-level strategies for business 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

Who is this book for?

This book is for developers and report designers using VB, C#, and ASP.NET who need to tie into SQL Server to build customized reports or to integrate reports into Windows or Web-based applications.


Chapter 1: Getting Started with Reporting Services.

Chapter 2: Reporting Services Architecture.

Chapter 3: Designing Reports.

Chapter 4: Designing Data Access.

Chapter 5: Advanced Report Design.

Chapter 6: Managing Reports Using the Report Manager.

Chapter 7: Managing Reports Using Program Code.

Chapter 8: Report Scripting.

Chapter 9: URL Access and Programmatic Rendering.

Chapter 10: Report Caching and Subscriptions.

Chapter 11: Report Definition Language.

Chapter 12: Extending Reporting Services.

Chapter 13: Deployment Strategies.

Chapter 14: Designing Business Intelligence Reporting Solutions.

Appendix A: Troubleshooting.

Appendix B: Migrating Access Reports.

Appendix C: Reporting Services Object Model.

Appendix D: Transact SQL Query Functions and Expressions.

Appendix E: Configuration Files.

Code Downloads
Code downloads for this title are available here.
Code and projects for all chapters (updated: 10/18/04)
All the code and projects at 1/2 the size in RAR format (updated: 10/18/04)
Code found in Chapter 7
Code found in Chapter 8
Code found in Chapter 9
Code found in Chapter 10
Code found in Chapter 12
Code found in Chapter 14
Missing File (updated: 10/18/04)
This portion of the "Report Definition Language" section was not included in the original downloadables. You may download the missing file here.
ChapterPageDetailsDatePrint Run
Errata for the book,
1 2 Bottom of the third paragraph "wanted" should be "had"