Microsoft SQL Server Reporting Services Recipes: For Designing Expert Reports

  • 7h 10m
  • Paul Turley, Robert M. Bruckner
  • John Wiley & Sons (US)
  • 2010

Learn to design more effective and sophisticated business reports

While most users of SQL Server Reporting Services are now comfortable designing and building simple reports, business today demands increasingly complex reporting. In this book, top Reporting Services design experts have contributed step-by-step recipes for creating various types of reports.

Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs

Coverage includes:

  • Business Reporting Paradigms
  • Basic Report Design Concepts
  • Using Report Builder.
  • Report Design Essentials
  • Tabular and Matrix Reports
  • Expressions and Custom Code
  • Formatting Report Data
  • Columnar and Grouped Reports
  • Bi Dashboards and Elements
  • Synchronizing Groups, Charts, and Sparklines
  • Chart and Gauge Reports
  • Creating a Personal Report Card
  • Creating a Multi-Series Multi-Y Axis Chart
  • Interactive Reporting
  • Integrated Reporting Applications
  • Offline Reporting Using The Report Viewer Control
  • Creating a Calendar Report
  • Creating Mailing Labels
  • Barcodes
  • Excel Worksheet Naming and Page Naming
  • External Image Sources
  • Language Localization
  • Creating a Checkbox List To Show Existing Records
  • Using a Checkbox List To Select and Deselect Records
  • Using The Map Wizard
  • Filtering and Parameterization
  • Multiple Criterion Report Filtering
  • Using Multi-Value Parameters with a Stored Procedure
  • Using Multi-Value Parameters with a Subscription Report
  • Creating Custom Sorting Reports
  • Filtering User-Specific Report Data
  • Custom and Dynamic Data Sources
  • Using a Web Service As a Data Source
  • Reporting On Sharepoint List Data
  • Dynamics Ax Report Wizard
  • and More!

The SQL Server Reporting Services Cookbook brings together great report designs that have been field-tested by the experts

About the Authors

Paul Turley is a business intelligence solution architect and manager for Hitachi Consulting. He is a Microsoft MVP and Certified Trainer. He designs solutions and teaches classes on SQL Server technologies to companies around the world. Paul is the author of several books, including Professional SQL Server Reporting Services (2000/2005/2008).

Robert M. Bruckner is a technical lead with the Microsoft SQL Server product team. His core area of responsibility is the development of the report processing engine of Reporting Services. Robert frequently shares Reporting Services tips on his popular blog at blogs.msdn.com/robertbruckner.

In this Book

  • Foreword
  • Introduction
  • Business Reporting Paradigms
  • Basic Report Design Concepts
  • Report Design Essentials
  • Columnar and Grouped Reports
  • BI Dashboards and Elements
  • Chart and Gauge Reports
  • Interactive Reporting
  • Integrated Reporting Applications
  • Enhanced Report Content
  • Filtering and Parameterization
  • Custom and Dynamic Data Sources
  • Games
SHOW MORE
FREE ACCESS