Microsoft SQL Server Reporting Services Recipes

for Designing Expert Reports
1. Auflage 2010
ISBN: 978-0-470-56311-3
Verlag: John Wiley and Sons Ltd

Buch, Englisch, 648 Seiten, Format (B × H): 187 mm x 236 mm, Gewicht: 1085 g

Lieferung vom Verlag mit leichten Qualitätsmängeln möglich

Autoren/Hrsg.

Turley, Paul

Bruckner, Robert M.

Fachgebiete

• Mathematik | Informatik EDV | Informatik Programmierung | Softwareentwicklung Datenbankprogrammierung SQL Server/MS SQL

Inhaltsverzeichnis

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.

Über Autor(innen)

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.