Microsoft SQL Server 2005 Reporting Services, Sams
Microsoft .NET Framework, ASP.NET, Visual C# (CSharp, C Sharp, C-Sharp) Developer Training, Visual Studio
|
Contents |
C# Online.NET Book Review
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