Reporting Services Recipes Book Downloads
The Reporting Services Recipes book contains detailed step-by-step instructions and explanations for each report design recipe. We also know that readers want to learn at their own pace, and sometimes don’t have the time to go step-by-step, but instead want to play with the final report first and then explore how it was built. As a courtesy, I am providing download links for most reports of the book’s 60+ recipes below. The majority of recipe reports were built in RDL 2005 and/or RDL 2008 format and use the AdventureWorks sample databases for SQL Server and Analysis Services, which you can download here.
I am going to cover several of these recipes in more detail in upcoming blog posts, especially those that are RS 2008 R2 specific. For now, please enjoy the download links:
- Complete Download (All Recipes, 5 MB)
- Readme File
- Shared Data Source Definitions - SSRS 2008
- Alternate Group Shading, pages 93-99
- Angry Koala Cube Browser Reports, pages 204-221
- Australian Sparkline, pages 185-203
- Barcodes, pages 391-399
- Bullet Chart, pages 222-227
- Calendar Report, pages 375-382
- Chart Custom Color Palette, pages 235-238
- Chart Keywords, pages 239-243
- Column Chart with Goal Line, pages 244-249
- Conditional Linking, pages 299-304
- Cube Browser, pages 163-184
- Cube Dynamic Rows, pages 139-147
- Cube Metadata, pages 148-162
- Cube Restricting Rows, pages 513-521
- Currency Translation, pages 400-406
- Custom Aggregation, pages 407-414
- Custom Sorting, pages 522-543
- Customizing Gauges With Images, pages 260-263
- Drill-through report hyperlink breadcrumbs, pages 318-325
- Dynamic Groups, pages 105-114
- Dynamic Page Breaks, pages 415-419, certain sub-solutions require RS 2008 R2
- Dynamic Pivot as a Matrix Substitute, pages 326-330
- Dynamics AX Report Wizard, pages 574-581
- Excel Worksheet Naming and Page Naming, pages 420-424, requires RS 2008 R2
- External Image Sources, pages 425-438
- Filtering User-specific Report Data, pages 544-550
- Green Bar Report, pages 85-92
- Grouped Pie Chart Slices, pages 268-271
- Highlighting With Gauges Bullet Graphs, pages 264-267
- Histogram Chart, pages 276-278
- Horizontal Table, pages 121-124
- Linear Regression Line, pages 279-285
- Localization, pages 439-446
- Mailing Labels, pages 383-390
- Multi-series Multi-Y Axis Chart, pages 286-292
- Multivalue Parameters to a Stored Procedure, pages 490-495
- Nested Group Green Bar Effect, pages 100-104, requires RS 2008 R2
- Offline Reporting, pages 359-372
- Page Running Total, pages 447-453, requires RS 2008 R2
- Parameterized Top Values, pages 506-512
- Pareto Chart, pages 293-297
- Personal Report Card, pages 250-259
- Renderer Dependent Layout and Formatting, pages 454-459, requires RS 2008 R2
- Report Usage Report, pages 341-346
- Reporting on SharePoint List Data, pages 561-573
- Resetting the Page Number Based on Groups, pages 125-127, requires RS 2008 R2
- Rotating Report Dashboard, pages 347-351
- Sea Battle Game, pages 591-600, more details here
- Select and Deselect List, pages 464-473
- Sparklines, pages 131-138
- Subscription Report with Parameters, pages 496-505
- Synchronizing Groups Chart and Sparklines, pages 228-232, requires RS 2008 R2
- Update Data Within a Report, pages 352-358
- Using a Document Map Table for Navigation, pages 331-337
- Using a Web Service as a Data Source, pages 553-560
- Using the Map Wizard, pages 474-478