| |
| |
Foreword | |
| |
| |
Acknowledgments | |
| |
| |
Introduction | |
| |
| |
| |
Getting Started | |
| |
| |
| |
Let's Start at the Very Beginning | |
| |
| |
Sharing Business Intelligence | |
| |
| |
The Need to Share | |
| |
| |
Possible Solutions | |
| |
| |
Microsoft Reporting Services | |
| |
| |
Report Authoring Architecture | |
| |
| |
The Business Intelligence Project Type | |
| |
| |
Report Structure | |
| |
| |
Report Designer | |
| |
| |
Report Serving Architecture | |
| |
| |
Report Server | |
| |
| |
Report Delivery | |
| |
| |
Diving In | |
| |
| |
| |
Putting the Pieces in Place: Installing Reporting Services | |
| |
| |
Preparing for the Installation | |
| |
| |
The Parts of the Whole | |
| |
| |
Editions of Reporting Services | |
| |
| |
Types of Reporting Services Installations | |
| |
| |
Installation Requirements | |
| |
| |
Other Installation Considerations | |
| |
| |
The Installation Process | |
| |
| |
The SQL Server 2005 Installation | |
| |
| |
The Report Server Configuration Manager | |
| |
| |
Common Installation Issues | |
| |
| |
Administrative Rights | |
| |
| |
Server Components Not Shown on the Feature Selection Screen | |
| |
| |
Installation Error 1603 | |
| |
| |
Installation Error 2755 | |
| |
| |
The Installation Log File | |
| |
| |
Spending Some Time in Basic Training | |
| |
| |
| |
Report Authoring | |
| |
| |
| |
DB 101: Database Basics | |
| |
| |
Database Structure | |
| |
| |
Getting Organized | |
| |
| |
Retrieving Data | |
| |
| |
Galactic Delivery Services | |
| |
| |
Company Background | |
| |
| |
Querying Data | |
| |
| |
The SELECT Query | |
| |
| |
On to the Reports | |
| |
| |
| |
A Visit to Emerald City: The Report Wizard | |
| |
| |
Your First Report | |
| |
| |
The Customer List Report | |
| |
| |
An Interactive Table Report | |
| |
| |
The Customer-Invoice Report | |
| |
| |
Creating Matrix Reports | |
| |
| |
The Invoice-Batch Number Report | |
| |
| |
Report Parameters | |
| |
| |
The Parameterized Invoice-Batch Number Report | |
| |
| |
Flying Solo | |
| |
| |
| |
Removing the Training Wheels: Building Basic Reports | |
| |
| |
Riding Down Familiar Roads | |
| |
| |
The Transport List Report | |
| |
| |
Data Regions | |
| |
| |
The Repair Count By Type Report | |
| |
| |
New Territory | |
| |
| |
The Transport Information Sheet | |
| |
| |
Getting Graphical | |
| |
| |
| |
Graphic Expression: Using Charts and Images in Reports | |
| |
| |
Chart Your Course | |
| |
| |
The Fuel Price Chart | |
| |
| |
The Fuel Price Chart, Version 2 | |
| |
| |
The Business Type Distribution Chart | |
| |
| |
The Days in Maintenance Chart | |
| |
| |
Image Is Everything | |
| |
| |
Conference Nametags | |
| |
| |
Conference Place Cards | |
| |
| |
The Rate Sheet Report | |
| |
| |
Building Higher | |
| |
| |
| |
Kicking It Up a Notch: Intermediate Reporting | |
| |
| |
Never Having to Say "I'm Sorry" | |
| |
| |
The Report Template | |
| |
| |
Handling Errors in Reports | |
| |
| |
The Employee Time Report | |
| |
| |
Data Caching During Preview | |
| |
| |
The Employee List Report | |
| |
| |
The Employee Mailing Labels Report | |
| |
| |
The Overtime Report | |
| |
| |
Under the Hood | |
| |
| |
Viewing the RDL | |
| |
| |
Practicing Safe Source | |
| |
| |
Using Visual SourceSafe | |
| |
| |
Advance, Never Retreat | |
| |
| |
| |
Beyond Wow: Advanced Reporting | |
| |
| |
Speaking in Code | |
| |
| |
The Delivery Status Report | |
| |
| |
The Lost Delivery Report | |
| |
| |
The Customer List Report-Revisited | |
| |
| |
Payroll Checks | |
| |
| |
The Weather Report | |
| |
| |
The Delivery Analysis Report | |
| |
| |
Reports Within Reports | |
| |
| |
The Employee Evaluation Report | |
| |
| |
The Invoice Report | |
| |
| |
Interacting with Reports | |
| |
| |
The Invoice Front-End Report | |
| |
| |
The Transport Monitor Report | |
| |
| |
A Conversion Experience | |
| |
| |
The Paid Invoices Report | |
| |
| |
What's Next | |
| |
| |
| |
A Leading Exporter: Exporting Reports to Other Rendering Formats | |
| |
| |
A Report in Any Other Format Would Look as Good | |
| |
| |
Exporting and Printing a Report | |
| |
| |
Presentation Formats | |
| |
| |
TIFF Image Presentation Format | |
| |
| |
Adobe PDF Presentation Format | |
| |
| |
Web Archive Presentation Format | |
| |
| |
Excel Presentation Format | |
| |
| |
Printed Presentation Format | |
| |
| |
HTML Presentation Format | |
| |
| |
Data Exchange Formats | |
| |
| |
Comma-Separated Values (CSV) Data Exchange Format | |
| |
| |
XML Data Exchange Format | |
| |
| |
Call the Manager | |
| |
| |
| |
Report Serving | |
| |
| |
| |
How Did We Ever Manage Without You? The Report Manager | |
| |
| |
Folders | |
| |
| |
The Report Manager | |
| |
| |
Moving Reports and Supporting Files to the Report Server | |
| |
| |
Deploying Reports Using the Report Designer | |
| |
| |
Uploading Reports Using Report Manager | |
| |
| |
Uploading Other Items Using Report Manager | |
| |
| |
Uploading Reports Using .NET Assemblies | |
| |
| |
Modifying Reports from the Report Server | |
| |
| |
Managing Items in Folders | |
| |
| |
Moving Items Between Folders | |
| |
| |
Deleting a Folder | |
| |
| |
Renaming a Folder | |
| |
| |
Seek and Ye Shall Find: Search and Find Functions | |
| |
| |
Searching for a Report | |
| |
| |
Finding Text Within a Report | |
| |
| |
Printing from Report Manager | |
| |
| |
Printing Options | |
| |
| |
Managing Reports on the Report Server | |
| |
| |
Security | |
| |
| |
Linked Reports | |
| |
| |
Creating a Linked Report | |
| |
| |
Delivering the Goods | |
| |
| |
| |
Delivering the Goods: Report Delivery | |
| |
| |
Caching In | |
| |
| |
Report Caching | |
| |
| |
Enabling Report Caching | |
| |
| |
Execution Snapshots | |
| |
| |
Enabling Execution Snapshots | |
| |
| |
Report History | |
| |
| |
Enabling Report History | |
| |
| |
Managing Report History Snapshots | |
| |
| |
Updating Report Definitions and Report History Snapshots | |
| |
| |
Subscriptions | |
| |
| |
Standard Subscriptions | |
| |
| |
Managing Your Subscriptions | |
| |
| |
Data-Driven Subscriptions | |
| |
| |
Site Settings | |
| |
| |
Configuration Options and Default Values | |
| |
| |
My Reports | |
| |
| |
Other Pages Accessed from the Site Settings Page | |
| |
| |
A Sense of Style | |
| |
| |
The ReportingServices Style Sheet | |
| |
| |
Building On | |
| |
| |
| |
Extending Outside the Box: Customizing Reporting Services | |
| |
| |
Using Reporting Services Without the Report Manager | |
| |
| |
URL Access | |
| |
| |
Web Service Access | |
| |
| |
The Report Viewer Control | |
| |
| |
SharePoint Web Parts | |
| |
| |
Reporting Services Utilities | |
| |
| |
Custom Security | |
| |
| |
Authentication and Authorization | |
| |
| |
Issues with Custom Security | |
| |
| |
Creating a Custom Security Extension | |
| |
| |
Deploying a Custom Security Extension | |
| |
| |
Using the Custom Security Extension | |
| |
| |
Other Extensions | |
| |
| |
Best Practices | |
| |
| |
Report-Authoring Practices | |
| |
| |
Report Deployment Practices | |
| |
| |
Where Do We Go from Here? | |
| |
| |
| |
Appendixes | |
| |
| |
| |
Report Item Reference | |
| |
| |
Report Objects | |
| |
| |
Layout Areas | |
| |
| |
Data Regions | |
| |
| |
Report Items | |
| |
| |
Property Reference | |
| |
| |
Properties | |
| |
| |
| |
Web Service Interface Reference | |
| |
| |
Reporting Services Web Service | |
| |
| |
Creating a Web Reference | |
| |
| |
Credentials | |
| |
| |
Code Sample | |
| |
| |
ReportExecution2005 Properties | |
| |
| |
ReportExecution 2005 Methods | |
| |
| |
ReportService2005 Properties | |
| |
| |
ReportService2005 Methods | |
| |
| |
ReportService2005 and ReportExecution2005 Web Service Classes | |
| |
| |
| |
Report Definition Language Reference | |
| |
| |
Report Definition Language | |
| |
| |
Default Values | |
| |
| |
RDL Structure | |
| |
| |
| |
Ad Hoc Reporting | |
| |
| |
The Report Model | |
| |
| |
Creating a Report Model | |
| |
| |
Creating Reports with the Report Builder | |
| |
| |
Report Builder Basics | |
| |
| |
Creating a Table Layout Report | |
| |
| |
Creating a Matrix Layout Report | |
| |
| |
Creating a Chart Layout Report | |
| |
| |
Give It a Try | |
| |
| |
Index | |