Microsoft SQL Server 2005 Reporting Services, Sams

Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio


Jump to: navigation, search
  Title:  Microsoft SQL Server 2005 Reporting Services
  Author(s):  Michael Lisin, Jim Joseph
  Edition:  Sams; 1st edition (March 22, 2006)
  Format:  Paperback: 480 pages
  ISBN:  0672327996
  Overall Rating:  Image:stars4.gif The Bottom Line
C# Online.NET:Reviews: Book Reviews  •  Educ./Train. Reviews  •  Software Reviews  •  Top 10 Books

Contents


C# Online.NET Book Review

Read a chapter from the book!

With version 2005, SQL Server Reporting Services has become a more powerful reporting tool. There are many new features including direct client printing, multivalued parameters, custom report items, Report Designer improvements, better integration with existing products including Visual Studio, and much more.

This relatively small book highlights most of the new SSRS 2005 features and enhancements. The first seventy pages or so are useful high level views—SSRS introduction, capabilities, architecture, and deployment scenarios. From there, the book becomes a tutorial on using the various capabilities and features—e.g., generating reports with Visual Studio, using Report Manager, using Web services. (See the Table of Contents).

All in all, the book is a very useful introduction and guide to SSRS. The book is concise and well organized and can serve as a mini reference. It has just the right tone and level of detail for a quick orientation followed by immediate application: It would be a good book for a developer doing a one-off SSRS project. However, it contains a dearth of source code examples.

All source code examples are in either the the C# or Visual Basic languages.


Bottom line

Microsoft SQL Server 2005 Reporting Services doubles as a helpful introduction and a useful tutorial to SSRS.

Publisher's description

SQL Server Reporting enables the creation, management, and delivery of both traditional, paper-oriented reports and interactive, Web-based reports. An integrated part of the Microsoft business intelligence framework, Reporting Services combines the data management capabilities of SQL Server and Microsoft Windows Server with familiar and powerful Microsoft Office System applications to deliver real-time information to support daily operations and drive decisions. Microsoft SQL Server 2005 Reporting Services will help you understand Reporting Services from various perspectives:

  • How it fits business scenarios
  • How to install and configure Reporting Services
  • Reporting Services components
  • Developing reports

As you progress to advanced user status, you will enjoy the chapter about accessing Reporting Services programmatically and extending Reporting Services, and you will be able to use this book as a convenient reference

About the author(s)

Michael Lisin has been in software industry for more than 12 years with 5 of those years with Microsoft. His primary focus is SQL Server and .NET technologies. He has been working with SQL Server for 4 years and SQL Server Reporting Services for almost 2 years starting from pre-beta in 2002. Michael has taught Reporting Services classes and presented SQL Server related topics during various events, including MSDN, SQL Server PASS and SQL Server User Group events.

Table of Contents (abbreviated)

Part I: Introduction to Reporting Services
1 Introduction to SQL Server Reporting Services (SSRS)
2 Reporting Services Capabilities: Presentation, Navigation, and Programmability
3 Reporting Services Architecture
4 Reporting Services Deployment Scenarios
5 Installing Reporting Services
Part II: Report Authoring from Basic to Advanced
6 Report Designer
7 Report Definition Language
8 Expressions
9 Accessing Data
10 Report Parameters
11 Working with Report Items
12 Grouping, Sorting, and Aggregating Data, Working with Scope
13 Advanced Report Formatting
14 Report Navigation
15 Working With Multidimensional Data Sources
16 Ad Hoc Reporting New in 2005
Part III: Reporting Services Administration and Operations
17 Managing Reports, Data Sources, and Models
18 Securing Report Server Items
19 Subscribing to Reports
20 Report Execution and Processing
21 Deploying and Configuring SSRS
Part IV: Developing for Reporting Services
22 Implementing Custom Embedded Code
23 How to Create and Call Custom Assembly from a Report
24 How to Use URL Access
25 How to Use Reporting Services Web Service
26 Writing Custom Reporting Services Extensions
27 Report Rendering Controls and SharePoint Services Web Parts
28 Custom Report Definition Language (RDL) Generators and Customizing Report Definition
Part V: Appendices
A References and Additional Reading
B Glossary
C FAQ

Personal tools