Book 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!
Microsoft® SQL Server® Reporting Services Recipes 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.
Table of contents
- Copyright
- CREDITS
- ABOUT THE AUTHORS
- ABOUT THE CONTRIBUTORS
- ACKNOWLEDGMENTS
- FOREWORD
- PREFACE
- INTRODUCTION
- 1. Business Reporting Paradigms
- 2. Basic Report Design Concepts
-
3. Report Design Essentials
-
3.1. TABULAR AND MATRIX REPORTS
- 3.1.1. Defining Table Groups
- 3.1.2. Matrix Reports
- 3.1.3. Sorting Options
- 3.1.4. Adding Headers and Footers
- 3.1.5. The Low Down on Drill-Down
- 3.1.6. Drill-Down
- 3.1.7. Creating a Drill-Down Report
- 3.1.8. Drill-Through Reports
- 3.1.9. Charting Basics
- 3.1.10. Gauges
- 3.1.11. Maps
- 3.1.12. Using Parameters
- 3.2. EXPRESSIONS AND CUSTOM CODE
- 3.3. FORMATTING REPORT DATA
- 3.4. SUMMARY
-
3.1. TABULAR AND MATRIX REPORTS
- I. Columnar and Grouped Reports
- II. BI Dashboards and Elements
- III. Chart and Gauge Reports
- IV. Interactive Reporting
- V. Integrated Reporting Applications
- VI. Enhanced Report Content
- VII. Filtering and Parameterization
- VIII. Custom and Dynamic Data Sources
- IX. Games
Product information
- Title: Microsoft® SQL Server® Reporting Services Recipes: for Designing Expert Reports
- Author(s):
- Release date: April 2010
- Publisher(s): Wrox
- ISBN: 9780470563113
You might also like
book
Beginning SQL Server Reporting Services
Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports …
book
Business Intelligence with SQL Server Reporting Services
Business Intelligence with SQL Server Reporting Services helps you deliver business intelligence with panache. Harness the …
video
Creating Reports with SQL Server 2012 Reporting Services
Creating Reports with SQL Server 2012 Reporting Services [Video] About This Video Create reports with tables, …
book
Microsoft SQL Server 2012 Reporting Services
Use your SQL Server skills to create and manage key data reports Deliver interactive business intelligence …