MICROSOFT SQL SERVER REPORTING SERIVCES RECIPES

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

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.