Landrum / Voytek / McGehee Pro SQL Server 2008 Reporting Services

1. ed
ISBN: 978-1-4302-0651-4
Verlag: Apress
Format: PDF
Kopierschutz: 1 - PDF Watermark

E-Book, Englisch, 424 Seiten

Pro SQL Server Reporting Services 2008 is the third edition of Apress' top book on Microsoft's enterprise-level reporting tool. The previous edition has sold some 2100 units over a two-year period. This revision, combined with the impending release of SQL Server 2008, breathes new life into the topic and into this book.

strongRodney Landrum/strong is a MCSE working as a systems engineer, database administrator, and data analyst for a software development company in Pensacola, Florida, that specializes in applications for the healthcare industry. He writes software reviews and feature articles for numerous magazines, including emWindows and .NET/em, emSQL Server/em, emConnected Home/em, emT-SQL Solutions/em, emMicrosoft Certified Professional/em, and emElectronic House/em.

Autoren/Hrsg.

Landrum, Rodney

Voytek, Walter

McGehee, Shawn

Inhaltsverzeichnis

1;Contents at a Glance;5
2;Contents;6
3;About the Authors;11
4;About the Technical Reviewer;12
5;Acknowledgments;13
6;Introduction;15
6.1;What This Book Covers;16
6.2;Who This Book Is For;17
6.3;Source Code;18
7;Introducing the Reporting Services Architecture;19
7.1;Understanding the Benefits of SSRS;20
7.2;Exploring the SSRS Architecture;25
7.3;Installing and Configuring;32
7.4;Deploying SSRS Securely;32
7.5;Summary;33
8;Report Authoring: Designing Efficient Queries;34
8.1;Introducing the Sample Relational Database;35
8.2;Introducing Query Design Basics;38
8.3;Using a Parameterized Stored Procedure;46
8.4;Summary;51
9;Introduction to Reporting Services Design;52
9.1;Exploring the Elements of BIDS;53
9.2;Laying Out a Report;68
9.3;Summary;101
10;Building Reports;102
10.1;Creating a Report with the Report Wizard;103
10.2;Building Reports from Scratch;106
10.3;Setting Report Parameters with Stored Procedures;134
10.4;Working with Multivalued Parameters;141
10.5;Adding Tablix Elements;151
10.6;Report and Group Variables;153
10.7;Adding the New Gauge Control;154
10.8;Adding the Final Touches;156
10.9;Summary;158
11;Using Custom .NET Code with Reports;159
11.1;Using Embedded Code in Your Report;160
11.2;Using Custom Assemblies with Your Report;168
11.3;Summary;182
12;Rendering Reports from .NET Applications;183
12.1;Implementing URL Access;185
12.2;Integrating SSRS 2008 with .NET Applications;189
12.3;Summary;215
13;Deploying Reports;216
13.1;Using Report Manager;217
13.2;Using Report Builder 2.0;221
13.3;Using BIDS and Visual Studio 2008;223
13.4;Using the rs.exe Utility;226
13.5;Using the Report Server Web Service;230
13.6;Summary;241
14;Managing Reports;242
14.1;Exploring Management Roles in SSRS Deployment;242
14.2;Managing Content;243
14.3;Performing Execution Auditing and Performance Analysis;266
14.4;Controlling SSRS Programmatically;273
14.5;Summary;286
15;Securing Reports;287
15.1;Encrypting Data;288
15.2;Setting Up Authentication and User Access to Data;299
15.3;Auditing Reports;313
15.4;Exploring Deployment Models;314
15.5;Summary;320
16;Delivering Business Intelligence with SSRS;321
16.1;Building SSRS Reports for SQL Analysis Services;322
16.2;Incorporating SSRS with Microsoft Office SharePoint Services 2007;332
16.3;Summary;350
17;Creating Reports Using Report Builder 1.0 and 2.0;351
17.1;Getting User Feedback;352
17.2;Introducing the Report Model;354
17.3;Creating Reports with Report Builder 1.0;372
17.4;Creating Reports with Report Builder 2.0;392
17.5;Summary;403
18;Index;404