Skip to content

SQL Server 2005 Reporting Services in Action Revised Edition of Microsoft Reporting Services in Action

Spend $50 to get a free movie!

ISBN-10: 1932394761

ISBN-13: 9781932394764

Edition: 2007 (Revised)

Authors: Bret Updegraff, Bret Updegraff

List price: $49.99
Blue ribbon 30 day, 100% satisfaction guarantee!
Out of stock
what's this?
Rush Rewards U
Members Receive:
Carrot Coin icon
XP icon
You have reached 400 XP and carrot coins. That is the daily max!

Description:

Written by experienced SQL Server developers, "SQL Server 2005 Reporting Services in Action" shows readers how to build Windows or Web-based reporting systems. This book covers features added to the newest version of Reporting Services such as client side sorting, custom report items, the new ReportViewer control, and much more. This book also focuses on the new ad-hoc reporting capablilities of Reporting Services. Specifically aimed at .NET developers, the book shows you how you can build Reporting Services-centric solutions, including report forecasting, RSS feeds, ASP.NET web controls for server-side report generation, extending Reporting Services to report on ADO.NET datasets,…    
Customers also bought

Book details

List price: $49.99
Copyright year: 2007
Publisher: Manning Publications Company
Publication date: 11/24/2006
Binding: Paperback
Pages: 656
Size: 7.50" wide x 9.00" long x 1.25" tall
Weight: 2.178
Language: English

Foreword
Foreword to the first edition
Preface
Preface to the first edition
Acknowledgments
About this book
About the source code
About the authors
About the cover illustration
Introducing SQL Server 2005 Reporting Services
What is Reporting Services?
Solving reporting problems with Reporting Services
Choosing a Reporting Services edition
Reporting Services and the Microsoft SQL Server platform
Reporting Services at a glance
Authoring features
Management features
Delivery features
Extensibility features
Scalability features
Security features
Deployment features
RS architecture
The Report Server engine
The Report Server database
The Report Manager
Understanding report processing
Execution stage
Rendering stage
Delivering reports
On-demand delivery
Subscribed delivery
What is the report lifecycle?
RS in action
About the Adventure Works Reporter
Your first report
Evaluating RS
Summary
Authoring reports
Report authoring basics
The report-authoring process: step by step
Analysis
Construction
Testing
Deployment
Authoring reports in VS .NET
Authoring reports with the Report Wizard
Authoring reports with the Report Designer
Importing reports from Microsoft Access
Creating reports programmatically
Generating RDL: The AW Ad Hoc Reporter
Implementation details
Summary
Working with data
Working with data sources
Connecting to the database
Choosing an authentication mechanism
Deploying data sources
Working with report datasets
Understanding the dataset definition
Creating a report dataset
Using multiple datasets
Authoring dataset queries
Using the Graphical Query Designer
Using the Generic Query Designer
Parameter-driven reports
The role of parameters
Building parameter-driven queries
Setting up the report-level parameters
Working with stored procedures
Using a stored procedure as a dataset query
Defining query-based lookup parameter values
Creating cascading parameters
Working with multivalued parameters
Summary
Designing reports
Anatomy of a report
Getting started with a new report
Understanding report sections
Understanding report items
Understanding data regions
Designing tabular reports
Tabular reports with groups
Parameterized tabular reports
Tabular reports with interactive features
Table region limitations
Designing freeform reports
Freeform reports with nested regions
Grouping freeform data
Freeform reports with side-by-side data regions
Designing chart reports
The chart data region
Working with charts
Nesting chart regions
Designing crosstab (matrix) reports
Matrix region advantages
Working with the matrix region
Adjusting the report layout
Using other design features in your reports
Setting up multiple columns
Adding interactive sort
Passing multivalued parameters into a stored procedure
Designing subreports
Summary
Using expressions and functions
Understanding expressions
Using the Expression Editor
Expression syntax
Determining expression execution order
Understanding expression scope
Dealing with expression errors
Exploring the Report Object Model
Using the ReportItems collection
Using the Fields collection
Using the Parameters collection
Using the Globals collection
Using the User collection
Working with functions
Referencing external functions
Using aggregate functions
Using other internal functions
Designing reports with navigational features
Reports with hyperlinks
Reports with document maps
Report rendering considerations
Exporting reports to HTML
Exporting reports to MHTML
Exporting reports to other formats
Summary
Using custom code
Understanding custom code
Using embedded code
Using external assemblies
Custom code in action: implementing report forecasting
Forecasting with OpenForecast
Implementing report forecasting features
Using XML-based reports
Understanding XML exporting
Exposing the report content as an RSS feed
Summary
Ad hoc reporting with the Report Builder application
About the Report Builder application
A quick tour of the Report Builder
Setting up for ad hoc reporting
The Developer toolset for ad hoc reporting
Building the Report Model using BIDS
Building a report model project
Setting up the data source
Creating a data source view
Building the report model
Deploying report models
Ad hoc reporting in action
Launching the Report Builder
Creating the Product Profit Margin report
Getting more with infinite drill-through reporting
Advanced filtering with the Report Builder
Implementing Report Builder security
Securing the Report Builder with roles
Securing report model items
Summary
Managing reports
Managing the Reporting Services environment
Managing RS with the Report Manager
How the Report Manager works
Managing Report Server settings
Managing content
Managing report execution
Managing linked reports
Managing RS with the Web service
Using the Web service management API
Tracing calls to the SOAP API
Deploying reports programmatically
Batching methods together
Managing RS with the WMI provider
Understanding the WMI provider
Implementing an RS management console
Other ways to manage Reporting Services
Managing RS with SQL Management Studio
Managing RS with the script host
Using the Reporting Services configuration tool
Analyzing report execution
Analyzing the Report Server execution log
Analyzing trace log files
Summary
Securing Reporting Services
Role-based security basics
The purpose of role-based security
Authentication models: using Windows or creating your own
Windows authentication: a closer look
Exploring the Client-to-Report Server model
Exploring the Client-to-Facade-to-Report Server model
Using role-based authorization
Understanding tasks
Defining roles
Understanding securable items
Defining policies
Managing role-based security with the Report Manager
Creating Windows user accounts and groups
Creating custom roles
Defining security policies
Managing role-based security with the Web service
Determining role-based security policies
Calling security-related Web service methods
Implementing "pseudo" report events
Techniques for advanced security issues
Filtering data
Using dynamic dataset queries
Hiding data
Implementing custom security models
Enforcing a secured connection to the Report Server
Summary
Delivering reports
On-demand report delivery
How RS provides on-demand report delivery
URL-based report access
Understanding URL syntax
Requesting resources by URL
Requesting reports by URL
Working with report commands
Working with the HTML Viewer
URL access in action
URL Access with WinForms: AccessOptions
URL Access with WebForms: AWReporterWeb
Web service-based report access
Requesting reports with SOAP
Rendering images
Handling report sessions
Web service access (SOAP) in action
Generating report requests with SOAP on the client side
An automation solution: AW Campaigner
Evaluating URL and Web service access options
Evaluating URL access
Evaluating Web service access
Choosing an integration approach
Summary
Mastering the ReportViewer controls
How the .NET ReportViewer controls work
Controls for web and Windows applications
Choosing remote or local mode
Managing properties of the ReportViewer controls
Using ReportViewer in remote mode
Creating, configuring, and running the control
Additional customizations for the ReportViewer control
Using Report Viewer in local mode
Creating a local report with a database as the data source
Creating a local report with an object as the data source
Custom validation with the ReportViewer control
Creating a parameters section
Creating event methods
Write validation code
Converting report files
Converting RDL files into RDLC files
Converting RDLC files into RDL files
Deploying applications that use ReportViewer controls
Redistributing the ReportViewer controls
ReportViewer deployment for Windows applications
ReportViewer deployment for web applications
Using the ReportViewer web server control in a web farm
Summary
Subscribed report delivery
Understanding subscribed report delivery
Subscription-based reporting scenarios
The subscriber-publisher design pattern
How the RS subscription-based model works
Configuring subscribed report delivery
Creating a new subscription
Choosing the subscription type
Configuring delivery extensions
Managing subscriptions
Subscribed report delivery in action
"Pushing" reports via standard e-mail subscriptions
Archiving reports to a file share
Sending reports to a data-driven list of recipients
Triggering subscriptions programmatically
Summary
Advanced reporting
Extending Reporting Services
Understanding Reporting Services extensibility
Interface-based programming
Working with interface inheritance
Extending RS with interface inheritance
Reporting with a custom dataset data extension
Identifying design goals and trade-offs
Authoring dataset-bound reports
Implementing the custom dataset extension
Debugging dataset extensions
Distributing reports to Web services using custom delivery extensions
Design goals and trade-offs
Using the custom delivery extension
Implementing the custom delivery extension
Debugging custom delivery extensions
Implementing custom security
Design goals and trade-offs
Intranet reporting with custom security
Implementing the custom security extension
Debugging the custom security extension
Summary
Performance and scalability
Understanding capacity planning
Capacity-planning fundamentals
The capacity-planning process
Capacity planning for Reporting Services in action
Determining requirements
Setting up the testing environment
Performance testing
Analyzing performance results
Identifying resource constraints
Eliminating resource constraints
Summary
Installing SQL Server Reporting Services
Software requirements
Installing SQL Server Reporting Services
Understanding .NET code access security
Code access security basics
Understanding code access terminology
Exploring the RS default security policy
Managing RS code access security
Resources
Index