Take full advantage of everything SQL Server 2008 Reporting Services has to offer and deliver customizable, web–enabled reports across your business at a reasonable cost. Learn best–practices from professionals who use SQL Server Reporting Services daily to deliver solutions to paying clients and gain the competitive edge on using Microsoft’s enterprise–level reporting platform.
- Provides best–practices for using Reporting Services
- Written by practicing professionals with paying clients
- Your key to delivering business intelligence across the enterprise
What you’ll learn
- Write efficient queries on which to base a report.
- Build and lay out a report using Report Designer.
- Enable end users to create ad hoc reports on demand.
- Combine Reporting Services with Analysis Services, SharePoint Portal Server, and other technologies to deliver business intelligence across the enterprise.
- Secure and audit your reports as part of your regulatory compliance efforts.
- Customize your reports using C# assemblies and embedded Visual Basic .NET code.
Who is this book for?
Data analysts, developers, database administrators, and others who develop and deploy reports using Microsoft SQL Server Reporting Services.
About the Apress Pro Series
The Apress Pro series books are practical, professional tutorials to keep you on and moving up the professional ladder.
You have gotten the job, now you need to hone your skills in these tough competitive times. The Apress Pro series expands your skills and expertise in exactly the areas you need. Master the content of a Pro book, and you will always be able to get the job done in a professional development project. Written by experts in their field, Pro series books from Apress give you the hard–won solutions to problems you will face in your professional programming career.
Author(s): Rodney Landrum, Walter J. Voytek II, Shawn McGehee
Series: The expert's voice in sql server
Publisher: Apress; Distributed to the book trade worldwide by Springer-Verlag New York
Year: 2008
Language: English
Pages: 425
City: Berkeley, CA :, New York, NY
Pro SQL Server 2008 Reporting Services......Page 1
Contents at a Glance......Page 7
Contents......Page 9
About the Authors......Page 15
About the Technical Reviewer......Page 17
Acknowledgments......Page 19
Introduction......Page 21
Introducing the Reporting Services Architecture......Page 25
Unknown......Page 0
Enhanced Charting Visualizations......Page 29
SSRS and Business Intelligence......Page 30
SQL Server Management Studio (SSMS)......Page 31
SSRS Databases......Page 32
The Report Processor......Page 33
Scheduling and Delivery......Page 34
Report Manager......Page 35
Business Intelligence Development Studio (BIDS)......Page 36
Custom Clients......Page 37
Report Authoring: Designing Efficient Queries......Page 41
Introducing the Schema Design......Page 42
Knowing Your Data: A Quick Trick with a Small Procedure......Page 43
Creating a Simple Query Graphically......Page 45
Creating an Advanced Query......Page 48
Testing Performance with SQL Server Management Studio (SSMS)......Page 50
Optimizing Performance: Dividing the Load......Page 52
Using Case and ISNULL to Evaluate the Parameters......Page 56
Testing the Procedure......Page 57
Introduction to Reporting Services Design......Page 59
Setting Up a Basic IDE......Page 62
Understanding Report Definition Language (RDL)......Page 63
Adding a Report......Page 64
Creating a Data Source......Page 65
Creating a Dataset......Page 67
Creating Other Data Sources......Page 69
Setting Parameters......Page 70
Setting Up Filters......Page 72
Expressions......Page 74
Setting Up Pagination......Page 76
Using Report Objects......Page 77
Implementing a List......Page 78
Implementing a Textbox......Page 82
Implementing a Table......Page 87
Implementing a Rectangle......Page 91
Implementing a Matrix......Page 95
Implementing a Chart......Page 98
Implementing an Image......Page 103
Implementing a Gauge......Page 106
Building Reports......Page 109
Formatting the Output......Page 115
Adding Subtotals......Page 116
Document Mapping......Page 119
Visibility......Page 121
Interactive Sorting......Page 124
Hyperlink Actions......Page 127
Applying a Filter......Page 154
Adding a Chart......Page 155
Using Custom .NET Code with Reports......Page 167
Using the ExceedMaxVisits Function......Page 169
Using the ExceedMaxVisits Function in a Report......Page 172
Accessing .NET Assemblies from Embedded Code......Page 175
Adding a Class Library Project to Your Reporting Solution......Page 177
Deploying a Custom Assembly......Page 180
Adding an Assembly Reference to a Report......Page 184
Debugging Custom Assemblies......Page 187
Troubleshooting Your Project......Page 189
Rendering Reports from .NET Applications......Page 191
URL Parameters and Prefixes......Page 194
HTML Viewer Commands......Page 195
Credential Parameters......Page 196
Example URLs......Page 197
Creating the Viewer Form......Page 198
Coding the Viewer Form......Page 199
Building the Report Viewer Using a Report Viewer Control......Page 201
Creating the Viewer Form......Page 202
Coding the Viewer Form......Page 203
Rendering the Report Locally......Page 205
Using the Report Server Web Service......Page 208
Rendering the Final Report......Page 216
Building the Report Viewer in ASP.NET......Page 219
Deploying Reports......Page 225
Configuring Report Deployment Options......Page 232
Deploying Reports Through the Solution Explorer......Page 234
Accessing the Web Service......Page 240
Laying Out the Form......Page 241
Identifying the SSRS 2008 Server......Page 242
Populating the TreeView Control......Page 243
Opening the RDL File and Uploading It to the Server......Page 245
Running the Application......Page 248
Managing Reports......Page 251
Setting Up Shared Schedules......Page 252
Creating a Shared Schedule......Page 253
Configuring a Report to Use a Shared Schedule......Page 254
Updating and Uploading the RDL File Using Report Manager......Page 256
Setting Up a Data Source for the Report......Page 258
Creating Snapshots for the Report History......Page 259
Executing Reports and Performing Caching......Page 262
Managing Subscriptions......Page 263
Managing Standard Subscriptions......Page 264
Managing Data-Driven Subscriptions......Page 270
Transforming the ExecutionLog Table......Page 276
Designing the Log Report......Page 278
Monitoring Performance......Page 280
Adding Subscription Functionality to SSRS Viewer......Page 283
Accessing an Existing Shared Schedule......Page 284
Scheduling the Report......Page 286
Delivering the Report......Page 291
Controlling SSRS with WMI......Page 294
Securing Reports......Page 297
Introducing Encryption......Page 298
Analyzing HTTP Traffic......Page 299
Applying the SSL Certificate......Page 303
Capturing HTTPS Traffic......Page 305
Securing Data Storage in SSRS......Page 307
Introducing SSRS Roles......Page 310
Testing SSRS Role Assignments......Page 314
Filtering Report Content with User!UserID......Page 319
Setting Data Source Security......Page 321
Setting SQL Server Permissions......Page 322
Introducing SSRS Auditing......Page 323
Introducing Log File Auditing......Page 324
Implementing SSRS with Terminal Services......Page 325
Implementing for Internal Access......Page 328
Delivering Business Intelligence with SSRS......Page 331
Using Analysis Service Cube with SSRS......Page 336
Setting Up the Analysis Services Data Source......Page 337
Working with the Graphical MDX Query Builder......Page 338
Installing MOSS and SharePoint on a Stand-Alone Server......Page 343
Deploying Reports in a MOSS-Integrated SSRS Installation......Page 351
Creating a Simple Dashboard to Display SSRS Reports......Page 357
Creating Reports Using Report Builder 1.0 and 2.0......Page 361
Adding a Report Model to BIDS......Page 365
Adding a Data Source......Page 366
Creating a Data Source View......Page 368
Creating a Report Model......Page 375
Creating a Table Report......Page 385
Creating a Matrix Report......Page 392
Creating a Chart Report......Page 397
Index......Page 415
