| |
| |
| 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 | |