At a Glance; Contents; About the Author; About the Technical Reviewer; Acknowledgments; Part I: Getting Started; Chapter 1: Getting Started; Understanding SSRS Architecture; Installing SQL Server with SSRS; Installing SQL Server Data Tools; Configuring SSRS; Configuring Local SSRS Settings; Determining the SQL Server Name; Restoring the AdventureWorks Database; Taking a Tour of SSDT; Summary; Chapter 2: Using the Wizard to Create Your First Reports; Creating Your First Report; Using the Preview Buttons; The Print Layout Button; The Page Setup Button; Additional Buttons
Text of Note
Chapter 5: Adding Grouping Levels to ReportsDesigning Your Report; The Report Requirements; The Report Layout; Building a Report with Grouping Levels; Add a Grouping Level to a Table Row; Add a Grouping Level to the Grouping Window; Formatting the Report; Sorting the Groups; Finalizing the Report; Building a Report with an Alternate Layout; Building a Report with a Space-Saving Layout; Building a Matrix Report; Summary; Chapter 6: Making Reports Dynamic; Adding Parameters to Report; The Hard-Coded Parameter List; Adding a Parameter List Based on a Query; Default Parameters
Text of Note
Creating Data SourcesDeploying Report Parts; Deploying Reports to SharePoint; Summary; Chapter 9: Securing Your Reports; Understanding SQL Server Security; Setting Up an SQL Account; Connecting to SQL Server; Configuring Site Security; Configuring Folder and Report Security; Sending Reports Automatically with Subscriptions; Securing Delivery; Summary; Chapter 10: Creating Self-Service and Mobile Reports; Using Report Builder; Creating KPIs; Creating Mobile Reports; Summary; Chapter 11: Where to Go from Here; SSRS Installation; Architecture and Configuration; Development; Administration
Text of Note
Formatting the Wizard ReportCreating a Matrix Report; Summary; Part II: Report Development; Chapter 3: Understanding Data Sources and Datasets; Creating Shared Data Sources; Creating Shared Datasets; Using Data Sources and Datasets; Using a Shared Dataset; Summary; Chapter 4: Working with Tables, Controls, and Report Sections; Working with Tables; Property Window Properties; Property Dialog Properties; Other Report Components; Page Headers; Table Cell Formatting; Page Footers; Report Cover Page; Text Boxes with Data; Calculated Fields; The List Control; Setting Report Properties; Summary
Text of Note
Multivalued ParametersCascading Parameters; Parameter Placement; Parameter Data Types; Using Stored Procedures; Controlling Properties; Visibility; Formatting; Interactive Sorting; Creating Drill Through Reports; Summary; Chapter 7: Bringing Data to Life Visually; Adding Charts and Graphs to Reports; Adding Gauges to Reports; Adding Data Bars, Sparklines, and Indicators to Tables; Adding a Map to a Report; Building a Dashboard; Summary; Part III: Deploying Reports; Chapter 8: Publishing Reports; Getting Around in the Web Portal; Deploying Reports from SSDT; Uploading Reports