Microsoft SQL Server Reporting Services Recipes
for Designing Expert Reports
(Sprache: Englisch)
Teaches how to design effective and sophisticated business reports. This book gives you the tools to meet your clients' needs. It enables you to create a wide variety of reports. It helps you customize reports for specific high-level needs and also to...
Leider schon ausverkauft
versandkostenfrei
Buch
43.90 €
Produktdetails
Produktinformationen zu „Microsoft SQL Server Reporting Services Recipes “
Teaches how to design effective and sophisticated business reports. This book gives you the tools to meet your clients' needs. It enables you to create a wide variety of reports. It helps you customize reports for specific high-level needs and also to resolve design problems. It covers recipes for grouped reports, charts, and composite reports.
Klappentext zu „Microsoft SQL Server Reporting Services Recipes “
Learn to design more effective and sophisticated business reportsWhile 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.
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
- SQL Server Reporting Services enables you to create a wide variety of reports
- This guide helps you customize reports for specific high-level needs and also to resolve design problems
- Covers recipes for grouped reports, charts, composite reports, dashboards, forms and labels, and interactive reports
- Also addresses localization, data sorting and filtering, handling dynamic data sources, and more
- Companion Web site provides samples of all the design solutions presented in the book
The SQL Server Reporting Services Cookbook brings together great report designs that have been field-tested by the experts
Written by well-known SQL Server Reporting Services experts, this book gives you the tools to meet your clients' needs
- SQL Server Reporting Services enables you to create a wide variety of reports
- This guide helps you customize reports for specific high-level needs and also to resolve design problems
- Covers recipes for grouped reports, charts, composite reports, dashboards, forms and labels, and interactive reports
- Also addresses localization, data sorting and filtering, handling dynamic data sources, and more
- Companion Web site provides samples of all the design solutions presented in the book
The SQL Server Reporting Services Cookbook brings together great report designs that have been field-tested by the experts
Inhaltsverzeichnis zu „Microsoft SQL Server Reporting Services Recipes “
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
... mehr
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.
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.
... weniger
Autoren-Porträt von Paul Turley, Robert M. Bruckner
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.
Bibliographische Angaben
- Autoren: Paul Turley , Robert M. Bruckner
- 2010, 1. Auflage., 648 Seiten, Maße: 17 x 25 cm, Kartoniert (TB), Englisch
- Verlag: Wiley & Sons
- ISBN-10: 0470563117
- ISBN-13: 9780470563113
Sprache:
Englisch
Kommentar zu "Microsoft SQL Server Reporting Services Recipes"
0 Gebrauchte Artikel zu „Microsoft SQL Server Reporting Services Recipes“
Zustand | Preis | Porto | Zahlung | Verkäufer | Rating |
---|
Schreiben Sie einen Kommentar zu "Microsoft SQL Server Reporting Services Recipes".
Kommentar verfassen