CONTENTS
vi
SSRS Architecture............................................................................................................. 7
SSRS Databases...................................................................................................................................... 8
The SSRS Report Server........................................................................................................................... 9
SSRS Web Service Interface..................................................................................................................... 9
Authentication Layer.............................................................................................................................. 10
The Report Processor............................................................................................................................ 10
Data Processing..................................................................................................................................... 10
Report Rendering................................................................................................................................... 11
Scheduling and Delivery........................................................................................................................ 11
Client Applications........................................................................................................... 12
Report Manager..................................................................................................................................... 12
Business Intelligence Development Studio (BIDS) and SQL Server Data Tools (SSDT)......................... 13
Command-Line Utilities......................................................................................................................... 14
Report Builder........................................................................................................................................ 14
Custom Clients....................................................................................................................................... 15
Installing and Configuring................................................................................................ 15
Deploying SSRS Securely................................................................................................ 16
Summary......................................................................................................................... 17
Chapter 2: Report Authoring: Designing Efficient Queries................................... 19
Introducing the Sample Relational Database................................................................... 19
Introducing the Schema Design............................................................................................................ 20
Knowing Your Data: A Quick Trick with a Small Procedure................................................................... 21
Introducing Query Design Basics..................................................................................... 23
Creating a Simple Query Graphically..................................................................................................... 23
Creating an Advanced Query................................................................................................................. 26
Testing Performance with SQL Server Management Studio (SSMS)..................................................... 28
Optimizing Performance: Dividing the Load.......................................................................................... 30