Microsoft SQL Server Reporting Services Recipes
for Designing Expert Reports
1st Edition
Published on 6. April 2010
Book
Paperback/Softback
648 pages
978-0-470-56311-3 (ISBN)
Description
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
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
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
Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.
More details
Persons
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 http://blogs.msdn.com/robertbruckner.
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 http://blogs.msdn.com/robertbruckner.
Content
FOREWORD.
PREFACE.
INTRODUCTION.
CHAPTER 1: BUSINESS REPORTING PARADIGMS.
Process and Operational Support.
Analytical Reporting.
Application Integration.
Server Reports.
CHAPTER 2: BASIC REPORT DESIGN CONCEPTS.
Using Report Builder.
CHAPTER 3: REPORT DESIGN ESSENTIALS.
Tabular and Matrix Reports.
Expressions and Custom Code.
Formatting Report Data.
PART I: COLUMNAR AND GROUPED REPORTS.
Green Bar Reports.
Alternate Background Shading for Table Groups.
Nested Group Green Bar Effect.
Creating Dynamic Groups.
Hiding and Showing Columns in a Table.
Horizontal Table.
Resetting the Page Number Based on Groups.
PART II: BI DASHBOARDS AND ELEMENTS.
Creating Sparklines.
Cube Dynamic Rows.
Cube Metadata.
Cube Browser.
Australian Sparklines.
Angry Koala Cube Browser.
Bullet Charts.
Synchronizing Groups, Charts, and Sparklines.
PART III: CHART AND GAUGE REPORTS.
Chart Custom Color Palette.
Chart Keywords.
Column Chart with Goal Threshold Line.
Creating a Personal Report Card.
Customizing Gauges with Images.
Exception Highlighting with Gauges/Bullet Graphs.
Grouped Pie Chart Slices.
Growing Bar and Column Charts.
Histogram Chart.
Linear Regression Line.
Creating a Multi-Series Multi-Y Axis Chart.
Pareto Chart.
PART IV: INTERACTIVE REPORTING.
Conditional Linking.
Drill-Through for a Multi-Level Matrix Report.
Drill-Through Report Link Breadcrumbs.
Dynamic Pivoting as a Matrix Replacement.
Using a Document Map Table for Navigation.
PART V: INTEGRATED REPORTING APPLICATIONS.
Creating a Report Server Usage Report.
Rotating Report Dashboard.
Updating Data From a Report.
Offline Reporting Using the Report Viewer Control.
PART VI: ENHANCED REPORT CONTENT.
Creating a Calendar Report.
Creating Mailing Labels.
Barcodes.
Currency Translation.
Custom Aggregation.
Dynamic (Conditional) Page Breaks.
Excel Worksheet Naming And Page Naming.
External Image Sources.
Language Localization.
Page Running Total.
Renderer-Dependent Layout and Formatting.
Creating a Checkbox List to Show Existing Records.
Using a Checkbox List to Select and Deselect Records.
Using the Map Wizard.
PART VII: FILTERING AND PARAMETERIZATION.
Multiple Criterion Report Filtering.
Using Multi-Value Parameters with a Stored Procedure.
Using Multi-Value Parameters with a Subscription Report.
Parameterized Top Values Report.
Cube Restricting Rows.
Creating Custom Sorting Reports.
Filtering User-Specific Report Data.
PART VIII: CUSTOM AND DYNAMIC DATA SOURCES.
Using aWeb Service as a Data Source.
Reporting on SharePoint List Data.
Dynamics AX Report Wizard.
PART IX: GAMES.
Hangman Game.
Sea Battle Game.
INDEX.
PREFACE.
INTRODUCTION.
CHAPTER 1: BUSINESS REPORTING PARADIGMS.
Process and Operational Support.
Analytical Reporting.
Application Integration.
Server Reports.
CHAPTER 2: BASIC REPORT DESIGN CONCEPTS.
Using Report Builder.
CHAPTER 3: REPORT DESIGN ESSENTIALS.
Tabular and Matrix Reports.
Expressions and Custom Code.
Formatting Report Data.
PART I: COLUMNAR AND GROUPED REPORTS.
Green Bar Reports.
Alternate Background Shading for Table Groups.
Nested Group Green Bar Effect.
Creating Dynamic Groups.
Hiding and Showing Columns in a Table.
Horizontal Table.
Resetting the Page Number Based on Groups.
PART II: BI DASHBOARDS AND ELEMENTS.
Creating Sparklines.
Cube Dynamic Rows.
Cube Metadata.
Cube Browser.
Australian Sparklines.
Angry Koala Cube Browser.
Bullet Charts.
Synchronizing Groups, Charts, and Sparklines.
PART III: CHART AND GAUGE REPORTS.
Chart Custom Color Palette.
Chart Keywords.
Column Chart with Goal Threshold Line.
Creating a Personal Report Card.
Customizing Gauges with Images.
Exception Highlighting with Gauges/Bullet Graphs.
Grouped Pie Chart Slices.
Growing Bar and Column Charts.
Histogram Chart.
Linear Regression Line.
Creating a Multi-Series Multi-Y Axis Chart.
Pareto Chart.
PART IV: INTERACTIVE REPORTING.
Conditional Linking.
Drill-Through for a Multi-Level Matrix Report.
Drill-Through Report Link Breadcrumbs.
Dynamic Pivoting as a Matrix Replacement.
Using a Document Map Table for Navigation.
PART V: INTEGRATED REPORTING APPLICATIONS.
Creating a Report Server Usage Report.
Rotating Report Dashboard.
Updating Data From a Report.
Offline Reporting Using the Report Viewer Control.
PART VI: ENHANCED REPORT CONTENT.
Creating a Calendar Report.
Creating Mailing Labels.
Barcodes.
Currency Translation.
Custom Aggregation.
Dynamic (Conditional) Page Breaks.
Excel Worksheet Naming And Page Naming.
External Image Sources.
Language Localization.
Page Running Total.
Renderer-Dependent Layout and Formatting.
Creating a Checkbox List to Show Existing Records.
Using a Checkbox List to Select and Deselect Records.
Using the Map Wizard.
PART VII: FILTERING AND PARAMETERIZATION.
Multiple Criterion Report Filtering.
Using Multi-Value Parameters with a Stored Procedure.
Using Multi-Value Parameters with a Subscription Report.
Parameterized Top Values Report.
Cube Restricting Rows.
Creating Custom Sorting Reports.
Filtering User-Specific Report Data.
PART VIII: CUSTOM AND DYNAMIC DATA SOURCES.
Using aWeb Service as a Data Source.
Reporting on SharePoint List Data.
Dynamics AX Report Wizard.
PART IX: GAMES.
Hangman Game.
Sea Battle Game.
INDEX.