Kellenberger Beginning SQL Server Reporting Services

1. ed
ISBN: 978-1-4842-1990-4
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 338 Seiten

Learn SQL Server Reporting Services and become current with the 2016 edition. Develop interactive, dynamic reports that combine graphs, charts, and tabular data into attractive dashboards and reports to delight business analysts and other users of corporate data. Deliver mobile reports to anywhere and any device. Build vital knowledge of Reporting Services at a time when Microsoft's dominance in business intelligence is on the rise. Beginning SQL Server Reporting Services turns novices into skilled report developers. The book begins by explaining how to set up the development environment. It then walks you through creating your first reports using the built-in wizard. After showing what is possible, the book breaks down and explains the skills needed to create reports from scratch. And not just reports! But also dashboards with charts, graphs, and maps. Each chapter builds on knowledge gained in the previous chapters with step-by-step tutorials. Beginning SQL Server Reporting Services boosts your skills and provides you additional career options. Don't be without those options. Grab and read this book today. Build reports with and without the built-in wizard. Build interactive features such as drill-through reports. Build dashboards full of charts, graphs, and maps. Build mobile reports.  
What You Will LearnSet up your development environment.
Organized projects and share components among reports.
Create report using a wizard.
Create reports from scratch, including grouping levels, parameters, and drill through features.
Deploy and manage reports for use by others in the business. 
Who This Book Is For
Beginning SQL Server Reporting Services is for database professionals of all experience levels who have some experience in databases and want to make the leap into business intelligence reporting. The book is an excellent choice for those needing to add Reporting Services to their current list of skills, or who are looking for a skill set that is in demand for in order to break into IT.


Kathi Kellenberger is a database consultant, trainer, author, and Microsoft Data Platform MVP. Kathi has contributed to over twelve SQL Server books as either an author, co-author, or technical editor. She also enjoys speaking and has presented at numerous SQL Server and .NET events and user group meetings around the US. When Kathi is not busy working or volunteering, she enjoys spending time with her grandchildren, cycling, and singing.  

Autoren/Hrsg.

Kellenberger, Kathi

Inhaltsverzeichnis

1;Contents at a Glance;6
2;Contents;8
3;About the Author;14
4;About the Technical Reviewer;16
5;Acknowledgments;18
6;Part I: Getting Started;19
6.1;Chapter 1: Getting Started;20
6.1.1;Understanding SSRS Architecture;21
6.1.2;Installing SQL Server with SSRS;22
6.1.3;Installing SQL Server Data Tools;28
6.1.4;Configuring SSRS;30
6.1.5;Configuring Local SSRS Settings;36
6.1.6;Determining the SQL Server Name;39
6.1.7;Restoring the AdventureWorks Database;40
6.1.8;Taking a Tour of SSDT;44
6.1.9;Summary;48
6.2;Chapter 2: Using the Wizard to Create Your First Reports;49
6.2.1;Creating Your First Report;49
6.2.2;Using the Preview Buttons;59
6.2.2.1;The Print Layout Button;60
6.2.2.2;The Page Setup Button;60
6.2.2.3;Additional Buttons;61
6.2.3;Formatting the Wizard Report;61
6.2.4;Creating a Matrix Report;68
6.2.5;Summary;73
7;Part II: Report Development;74
7.1;Chapter 3: Understanding Data Sources and Datasets;75
7.1.1;Creating Shared Data Sources;75
7.1.2;Creating Shared Datasets;81
7.1.3;Using Data Sources and Datasets;83
7.1.4;Using a Shared Dataset;91
7.1.5;Summary;95
7.2;Chapter 4: Working with Tables, Controls, and Report Sections;96
7.2.1;Working with Tables;96
7.2.1.1;Property Window Properties;100
7.2.1.2;Property Dialog Properties;102
7.2.2;Other Report Components;107
7.2.2.1;Page Headers;107
7.2.2.2;Table Cell Formatting;109
7.2.2.3;Page Footers;111
7.2.2.4;Report Cover Page;112
7.2.2.5;Text Boxes with Data;115
7.2.2.6;Calculated Fields;115
7.2.2.7;The List Control;119
7.2.3;Setting Report Properties;121
7.2.4;Summary;123
7.3;Chapter 5: Adding Grouping Levels to Reports;124
7.3.1;Designing Your Report;124
7.3.1.1;The Report Requirements;124
7.3.1.2;The Report Layout;125
7.3.2;Building a Report with Grouping Levels;125
7.3.2.1;Add a Grouping Level to a Table Row;126
7.3.2.2;Add a Grouping Level to the Grouping Window;129
7.3.2.3;Formatting the Report;131
7.3.2.4;Sorting the Groups;135
7.3.2.5;Finalizing the Report;136
7.3.3;Building a Report with an Alternate Layout;137
7.3.4;Building a Report with a Space-Saving Layout;141
7.3.5;Building a Matrix Report;142
7.3.6;Summary;146
7.4;Chapter 6: Making Reports Dynamic;147
7.4.1;Adding Parameters to Report;147
7.4.1.1;The Hard-Coded Parameter List;150
7.4.1.2;Adding a Parameter List Based on a Query;151
7.4.1.3;Default Parameters;155
7.4.1.4;Multivalued Parameters;157
7.4.1.5;Cascading Parameters;158
7.4.1.6;Parameter Placement;159
7.4.1.7;Parameter Data Types;160
7.4.1.8;Using Stored Procedures;162
7.4.2;Controlling Properties;168
7.4.2.1;Visibility;168
7.4.2.2;Formatting;175
7.4.2.3;Interactive Sorting;176
7.4.3;Creating Drill Through Reports;179
7.4.4;Summary;182
7.5;Chapter 7: Bringing Data to Life Visually;183
7.5.1;Adding Charts and Graphs to Reports;183
7.5.2;Adding Gauges to Reports;208
7.5.3;Adding Data Bars, Sparklines, and Indicators to Tables;214
7.5.4;Adding a Map to a Report;222
7.5.5;Building a Dashboard;229
7.5.6;Summary;234
8;Part III: Deploying Reports;235
8.1;Chapter 8: Publishing Reports;236
8.1.1;Getting Around in the Web Portal;236
8.1.2;Deploying Reports from SSDT;240
8.1.3;Uploading Reports;249
8.1.4;Creating Data Sources;252
8.1.5;Deploying Report Parts;253
8.1.6;Deploying Reports to SharePoint;256
8.1.7;Summary;262
8.2;Chapter 9: Securing Your Reports;263
8.2.1;Understanding SQL Server Security;263
8.2.1.1;Setting Up an SQL Account;264
8.2.1.2;Connecting to SQL Server;269
8.2.2;Configuring Site Security;273
8.2.3;Configuring Folder and Report Security;275
8.2.4;Sending Reports Automatically with Subscriptions;279
8.2.5;Securing Delivery;285
8.2.6;Summary;286
8.3;Chapter 10: Creating Self-Service and Mobile Reports;287
8.3.1;Using Report Builder;287
8.3.2;Creating KPIs;299
8.3.3;Creating Mobile Reports;308
8.3.4;Summary;327
8.4;Chapter 11: Where to Go from Here;328
8.4.1;SSRS Installation;328
8.4.2;Architecture and Configuration;330
8.4.3;Development;331
8.4.4;Administration;331
8.4.5;Integration;332
8.4.6;Summary;333
9;Index;334