| |
| |
Introduction | |
| |
| |
How This Book Is Organized | |
| |
| |
How to Use This Book | |
| |
| |
Foolish Assumptions I Make about You | |
| |
| |
Icons Used in This Book | |
| |
| |
Getting Started | |
| |
| |
| |
Just the Basics | |
| |
| |
| |
Getting Familiar with Reporting Services | |
| |
| |
Dealing with Reporting Challenges | |
| |
| |
Mastering Reporting Principles | |
| |
| |
Investigating Business Data | |
| |
| |
Uncovering the Major Features of Reporting Services | |
| |
| |
Accessing and Looking at Reports | |
| |
| |
| |
Retrieving Data from a Database | |
| |
| |
Discovering What Makes a Database | |
| |
| |
Keying In on Your Data | |
| |
| |
Striking up a Relationship with Your Data | |
| |
| |
Building a SQL Query | |
| |
| |
| |
Building and Running a Simple Report | |
| |
| |
Facing Down the BI Development Studio | |
| |
| |
Working with Your Reporting Project | |
| |
| |
Modifying Your Report | |
| |
| |
| |
Building Reports - Your Creativity Options | |
| |
| |
| |
We're Off to See the Wizard | |
| |
| |
Accessing the Wizard | |
| |
| |
Establishing the Data Source | |
| |
| |
Querying the Data | |
| |
| |
Designing the Table and Styles | |
| |
| |
Laying Out the Report - Layout and Style | |
| |
| |
| |
Styling with Report Types | |
| |
| |
Report Design Surface | |
| |
| |
Working with Data Regions and Other Report Items | |
| |
| |
| |
Accessorizing Your Reports | |
| |
| |
Sorting, Grouping, and Filtering | |
| |
| |
| |
Reporting with Parameters and Format Options | |
| |
| |
Using Expressions | |
| |
| |
Discovering How to Use Parameters | |
| |
| |
Formatting Reports | |
| |
| |
| |
Using Report Builder | |
| |
| |
Creating a Report Model | |
| |
| |
Working with the Report Builder | |
| |
| |
Publishing Report Builder Reports to Report Manager | |
| |
| |
| |
Publishing, Accessing, and Subscribing to Reports | |
| |
| |
| |
Publish or Perish - Getting the Report Out | |
| |
| |
Deploying Reports | |
| |
| |
Introducing the Report Manager | |
| |
| |
Getting Around in Report Manager | |
| |
| |
Exporting Reports to Other Formats | |
| |
| |
Design Considerations for Each Rendering Extension | |
| |
| |
Archiving Reports | |
| |
| |
| |
Executing and Accessing Reports on Demand | |
| |
| |
Understanding the Pull Model | |
| |
| |
Saving Your Cache | |
| |
| |
Organizing Snapshots | |
| |
| |
Creating a Historical Perspective | |
| |
| |
Summary of Report Execution Methods | |
| |
| |
| |
Delivering Your Reports | |
| |
| |
Automating the Delivery of Reports | |
| |
| |
Getting Familiar with Subscription Components | |
| |
| |
Creating Standard Subscriptions | |
| |
| |
Creating Data-Driven Subscriptions | |
| |
| |
Using Subscription for Common Business Scenarios | |
| |
| |
Maintaining Your Subscriptions | |
| |
| |
Configuring Subscription Processing | |
| |
| |
| |
Maintaining Your Reports | |
| |
| |
| |
Managing and Administering Your Reports | |
| |
| |
Managing Your Reports | |
| |
| |
Administering Reporting Services | |
| |
| |
| |
Securing Report Server | |
| |
| |
Understanding Security Fundamentals | |
| |
| |
Introducing the Authorization Model | |
| |
| |
Best Practices for Protecting Against an Attack | |
| |
| |
| |
Optimizing Report Performance | |
| |
| |
Monitoring Report Server Performance | |
| |
| |
Strategy for Performance Tuning | |
| |
| |
Understanding Database Requirements for Report Server | |
| |
| |
Configuring Reporting Services Components | |
| |
| |
| |
Developing Advanced Reports | |
| |
| |
| |
More About Interactive Reporting | |
| |
| |
Using Visibility Options | |
| |
| |
Using Navigation Techniques | |
| |
| |
Using Document Maps | |
| |
| |
Using Tooltips | |
| |
| |
Interactive Sorting | |
| |
| |
| |
Drilling Down to the Details | |
| |
| |
Drilling from Summary to Detail | |
| |
| |
Drilling Down and Pivoting on Detail Lines | |
| |
| |
Providing Multiple Drill-down Options | |
| |
| |
Providing Navigation Links to Reports | |
| |
| |
Handling Multiple Drill Paths | |
| |
| |
Preparing a Report Menu Page | |
| |
| |
| |
Reporting from OLAP Data Sources | |
| |
| |
Discovering OLAP Capabilities | |
| |
| |
Speaking the Language of OLAP | |
| |
| |
Creating Reports with OLAP Cubes | |
| |
| |
| |
Helping Executives See the Big Business Picture | |
| |
| |
Monitoring Enterprise Performance | |
| |
| |
Building the Presentation | |
| |
| |
Accessories to the Executive Analysis | |
| |
| |
| |
Migrating from Other Reporting Tools | |
| |
| |
| |
Comparing Reporting Services to Other Popular Reporting Tools | |
| |
| |
Introducing Other Reporting Platforms | |
| |
| |
Comparing Data Retrieval Features | |
| |
| |
Comparing Report Development | |
| |
| |
Comparing Publish, Subscribe, and Access | |
| |
| |
Comparing Management and Administration of Reports | |
| |
| |
Comparing Advanced Reporting Capabilities | |
| |
| |
Comparing Price | |
| |
| |
Tool Comparison Takeaways | |
| |
| |
| |
Converting Reports from Access | |
| |
| |
Importing the Access Report | |
| |
| |
Upsizing an Access Database and Reports | |
| |
| |
| |
The Part of Tens | |
| |
| |
| |
Ten Cool Tricks with Reporting Services | |
| |
| |
Greenbar Paper Formatting | |
| |
| |
Controlling Page Breaks | |
| |
| |
Running Totals | |
| |
| |
Simulating End-User Sorting | |
| |
| |
Simulating the All Parameter Value | |
| |
| |
Dynamically Creating a Report Query | |
| |
| |
Changing the Report Manager Folder Icon to a Corporate Logo | |
| |
| |
Suppressing Objects or Formulas in an Excel Rendering of a Report | |
| |
| |
Securing Reports with a UserID Parameter | |
| |
| |
Measuring and Improving Report Performance | |
| |
| |
| |
Ten Ways to Hook Into the Microsoft BI Platform | |
| |
| |
Analysis Services | |
| |
| |
Integration Services | |
| |
| |
Data Mining | |
| |
| |
Reporting Services | |
| |
| |
Clustering Support | |
| |
| |
Key Performance Indicators | |
| |
| |
Scalability and Performance | |
| |
| |
One-Click Cube | |
| |
| |
Proactive Caching | |
| |
| |
Integration with Microsoft Office | |
| |
| |
| |
Ten Places to Find Reporting Services Support | |
| |
| |
Microsoft SQL Server | |
| |
| |
Reporting Services Web Site | |
| |
| |
Sample Databases for Reporting | |
| |
| |
Report Packs | |
| |
| |
Reporting Services Newsgroup | |
| |
| |
Chat or Webcast | |
| |
| |
OLAP Reporting | |
| |
| |
SQL Server Magazine | |
| |
| |
SQL Server Development Center | |
| |
| |
General BI Links | |
| |
| |
| |
Ten Third Party Tools to Use with Reporting Services | |
| |
| |
Attunity | |
| |
| |
Cizer Software | |
| |
| |
Dundas Software | |
| |
| |
Fenestrae | |
| |
| |
GFI | |
| |
| |
OutlookSoft | |
| |
| |
Panorama Software | |
| |
| |
ProClarity | |
| |
| |
Proposion | |
| |
| |
OfficeWriter | |
| |
| |
Index | |