| | Copyright |
| | About the Authors |
| | Acknowledgments |
| | We Want to Hear from You! |
| | Introduction |
| | Part I: Introduction to Reporting Services |
| | | Chapter 1. Introduction to SQL Server Reporting Services (SSRS) |
| | | What Is SSRS? |
| | | SSRS for End Users |
| | | Overview of Features |
| | | Enterprise Report Examples |
| | | SSRS in the Report Development Life Cycle |
| | | Editions of Reporting Services |
| | | How Is SSRS Licensed? |
| | | Summary |
| | | Chapter 2. Reporting Services Capabilities: Presentation, Navigation, and Programmability |
| | | Report Layouts |
| | | Report Presentation (Rendering) Formats |
| | | Report Items, Visual Effects, and Charting |
| | | Report Navigation |
| | | Ad Hoc Reports NEW in 2005 |
| | | Reporting Services Data Access Features |
| | | Programmability |
| | | Summary |
| | | Chapter 3. Reporting Services Architecture |
| | | Report Server Web and Windows Service |
| | | Programmatic Interfaces |
| | | Report Processor |
| | | Command-Line Utilities |
| | | Reporting Services Extensions |
| | | Report Server Databases |
| | | Scheduling and Delivery Processor |
| | | Report Builder NEW in 2005 |
| | | Report Model Designer NEW in 2005 |
| | | Report Designer |
| | | Report Manager |
| | | SQL Server Management Studio NEW in 2005 |
| | | Reporting Services Configuration Tool NEW in 2005 |
| | | RSPrintClient Control NEW in 2005 |
| | | WMI Provider |
| | | Performance Monitoring Objects |
| | | Summary |
| | | Chapter 4. Reporting Services Deployment Scenarios |
| | | High-Availability Deployment Considerations |
| | | Internet Deployment Considerations |
| | | Minimum Hardware Requirements |
| | | Software Requirements |
| | | Key Features of SSRS by SQL Server 2005 Editions |
| | | Licensing |
| | | Summary |
| | | Chapter 5. Installing Reporting Services |
| | | Summary |
| | Part II: Report Authoring from Basic to Advanced |
| | | Chapter 6. Report Designer |
| | | Two Main Report Designers from Microsoft |
| | | Visual Studio Haves Versus Have Nots |
| | | Solution, Project, File Hierarchy |
| | | Generating Reports with Visual Studio |
| | | Summary |
| | | Chapter 7. Report Definition Language |
| | | Language: A Way to Communicate |
| | | Use of XML |
| | | Declarative Programming |
| | | Report Elements |
| | | Summary |
| | | Chapter 8. Expressions |
| | | What Is an Expression? |
| | | Expression Syntax |
| | | Adding Expressions |
| | | Collections |
| | | Using Functions |
| | | Other Functions |
| | | Using Expressions to Change Report Item Properties and Behavior |
| | | Example: Placing Emphasis on Certain Values |
| | | Summary |
| | | Chapter 9. Accessing Data |
| | | Data-Processing Extensions |
| | | Types of Data Sources |
| | | Connection Strings |
| | | Querying Data |
| | | Adding a Data Source |
| | | Summary |
| | | Chapter 10. Report Parameters |
| | | Setting Up Parameters |
| | | Parameter Properties |
| | | Data-Driven Parameters |
| | | Parameters and Data Sources |
| | | Expressions with Parameters |
| | | Dynamic SQL with Parameters |
| | | Parameter Dependencies |
| | | Example Using MultiValueNEW in 2005 |
| | | Summary |
| | | Chapter 11. Working with Report Items |
| | | Data Regions, Containers, and Independent Report Items |
| | | Report Designer's Toolbox |
| | | Line Report Item |
| | | Rectangle Report Item |
| | | Image Report Item |
| | | Textbox Report Item |
| | | Table Report Item |
| | | List Report Item |
| | | Practical Application of Report Items |
| | | Matrix Report Item |
| | | Chart Report Item |
| | | Chart Data (Value) |
| | | Chart Series Groups |
| | | Chart Category Groups |
| | | Chart's RDL |
| | | Practical Application of Chart and Matrix |
| | | Report Body Versus Page Header/Footer |
| | | Summary |
| | | Chapter 12. Grouping, Sorting, and Aggregating Data, Working with Scope |
| | | Grouping Data on a Report |
| | | Sorting, Including Interactive User Sorting |
| | | Interactive SortingNEW in 2005 |
| | | Data Source Sorting |
| | | Data Region and Group Sorting |
| | | Scope of an Aggregate Function |
| | | Level and InScope Functions |
| | | Summary |
| | | Chapter 13. Advanced Report Formatting |
| | | Formatting-Related Report Item Properties |
| | | Formatting Numeric and Date/Time Values |
| | | Standard Date/Time Format Strings |
| | | Custom Date/Time Formatting |
| | | Creating Alternating Colors for the Lines on a Report |
| | | Paging Report |
| | | Summary |
| | | Chapter 14. Report Navigation |
| | | Hyperlink (Jump to URL) Navigation |
| | | BookmarkLink (Jump to Bookmark) Navigation |
| | | Document Map |
| | | Drillthrough (Jump to Report) Navigation |
| | | Hiding Items and Toggle Items |
| | | Practical Application of Action Items |
| | | Summary |
| | | Chapter 15. Working with Multidimensional Data Sources |
| | | Analysis Services Concepts |
| | | Data-Mining Concepts |
| | | Summary |
| | | Chapter 16. Ad Hoc Reporting New in 2005 |
| | | Issues Facing Ad Hoc Reporting |
| | | Client-side Reporting with SSRS |
| | | Report Models and the Model Designer |
| | | Report Model Projects |
| | | Model File Content |
| | | Features of Report Builder |
| | | Building Reports with Report Builder |
| | | Summary |
| | Part III: Reporting Services Administration and Operations |
| | | Chapter 17. Managing Reports, Data Sources, and Models |
| | | Deployment Options in Visual Studio |
| | | Deployment Through Report Manager |
| | | Deploying Reports Through SQL Server Management Studio |
| | | Changing Report Properties |
| | | Setting Report History and Snapshots |
| | | My Reports |
| | | Summary |
| | | Chapter 18. Securing Report Server Items |
| | | Reporting Services Security Model |
| | | What Can Be Secured? |
| | | How Role Assignments Work |
| | | Relationships Between Roles, Tasks, and Users |
| | | Overview of Built-In Roles |
| | | Assigning Built-In Roles |
| | | Defining Custom Roles |
| | | Summary |
| | | Chapter 19. Subscribing to Reports |
| | | Overview of Subscriptions |
| | | Overview of Delivery Extensions |
| | | Creating a Simple Subscription |
| | | Creating a Data-Driven Subscription |
| | | Managing Subscriptions |
| | | Summary |
| | | Chapter 20. Report Execution and Processing |
| | | Managing Schedules |
| | | Report Execution and Processing |
| | | Report Execution History |
| | | Summary |
| | | Chapter 21. Deploying and Configuring SSRS |
| | | Overview of Deployment Scenarios |
| | | Requirements for a Standard Deployment |
| | | Requirements for a Scale-Out Deployment |
| | | Configuring SSRS |
| | | Key Management |
| | | Summary |
| | Part IV: Developing for Reporting Services |
| | | Chapter 22. Implementing Custom Embedded Functions |
| | | Adding Embedded Code |
| | | Debugging Embedded Code |
| | | Summary |
| | | Chapter 23. How to Create and Call a Custom Assembly from a Report |
| | | Strong-Named Custom Assemblies |
| | | NET Security Primer for a SSRS Administrator |
| | | Assemblies That Require Other Than Execute Permissions |
| | | Debugging Custom Assemblies |
| | | Summary |
| | | Chapter 24. How to Integrate URL Access |
| | | How to Integrate URL Access in an Application |
| | | Summary |
| | | Chapter 25. How to Use Reporting Services Web Services |
| | | Report Management Web Service New in 2005 (ReportService2005.asmx) |
| | | How to Script Reporting Services (Using the RS Utility) |
| | | Working with Report Parameters |
| | | Security When Calling a Web Service |
| | | Some of the Commonly Used Methods with Short Code Snippets |
| | | Summary |
| | | Chapter 26. Writing Custom Reporting Services Extensions |
| | | Common Considerations for Custom Reporting Services Extensions: Implementation, Deployment, and Security |
| | | Delivery Extension |
| | | Interactions Between User, SSRS, and a Delivery Extension |
| | | Summary |
| | | Chapter 27. Report Rendering Controls and SharePoint Services Web Parts |
| | | Microsoft Visual Studio 2005 ReportViewer Web and Windows Controls New in 2005 |
| | | Microsoft SharePoint Web Parts |
| | | Summary |
| | | Chapter 28. Custom Report Definition Language (RDL) Generators and Customizing Report Definition |
| | | Summary |
| | Part V: Appendices |
| | | Appendix A. References and Additional Reading |
| | |
| | | Appendix B. Glossary |
| | |
| | | Appendix C. FAQ |
| | Index |