Microsoft SQL Server Reporting Services Recipes: for Designing Expert Reports -- CONTENTS -- FOREWORD -- PREFACE -- INTRODUCTION -- Chapter 1: Business Reporting Paradigms -- PROCESS AND OPERATIONAL SUPPORT -- ANALYTICAL REPORTING -- APPLICATION INTEGRATION -- SERVER REPORTS -- SUMMARY -- Chapter 2: Basic Report Design Concepts -- USING REPORT BUILDER -- DATASETS AND QUERIES -- FILTERING DATA -- REPORTS AND REPORT OBJECTS -- THE TABLIX -- SUMMARY -- Chapter 3: Report Design Essentials -- TABULAR AND MATRIX REPORTS -- EXPRESSIONS AND CUSTOM CODE -- FORMATTING REPORT DATA -- SUMMARY -- PART I: Columnar and Grouped Reports -- GREEN BAR REPORTS -- ALTERNATE BACKGROUND SHADING FORTABLE 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 A WEB SERVICE AS A DATA SOURCE -- REPORTING ON SHAREPOINT LIST DATA -- DYNAMICS AX REPORT WIZARD -- PART IX: Games -- HANGMAN GAME -- SEA BATTLE GAME -- INDEX.