- Teaches solution architects, designers, and developers how to use Microsoft's reporting platform to create reporting and business intelligence (BI) solutions
- Updated with new information about holistic BI solutions, comprehensive OLAP/Analysis Services reporting, and complete production deployment scenarios
- Includes programming examples focused on specific, scenario-based solutions
- Explains reporting services architecture and business intelligence, teaches the fundamentals of designing reports through the use of careful planning considerations, and covers advanced report design and filtering techniques
Part I: Getting Started.
Chapter 1: Introducing Reporting Services.
Chapter 2: Business Intelligence Solutions.
Chapter 3: Reporting Services Installation.
Chapter 4: Reporting Services Architecture.
Part II: Report Design.
Chapter 5: Basic Report Design.
Chapter 6: Report Layout and Formatting.
Chapter 7: Designing Data Access.
Chapter 8: Advanced Report Design.
Part III: Business Intelligence Reporting.
Chapter 9: Reporting with Analysis Services.
Chapter 10: Report Solution Patterns and Recipes.
Part IV: Enabling End-User Reporting with Report Builder 1.0.
Chapter 11: Report Models.
Chapter 12: Report Builder 1.0.
Part V: Administering Reporting Services.
Chapter 13: Content Management.
Chapter 14: Report Server Administration.
Part VI: Reporting Services Integration and Custom Programming.
Chapter 15: Integrating Reports into Custom Applications.
Chapter 16: Integrating Reports with SharePoint.
Chapter 17: Extending Reporting Services.
Appendix A: RDL Object Model.
Appendix B: T - SQL Command Syntax Reference.
Appendix C: T - SQL System Variables and Functions.
Appendix D: MDX Reference.
|137||Error in Code|
The T-SQL script should be corrected so this line reads:
ON F.SalesTerritoryKey = ST.SalesTerritoryKey
|141||Error in Text|
In order to reproduce the results shown in Chapter 6, one correction and additional step is necessary:
On page 141 - Group the details on the SalesTerritoryRegion field
After adding the CalendarYear and SalesTerritory Region groups shown on page 140, it is neccesary to add a detail row group expression for the SalesTerritoryRegion field. To do this, click the down arrow on the (DetailsGroup) in the Row Groups list and choose Group Properties. In the Group Properties dialog, click the Add button under Group expressions. Choose the [SalesTerritoryRegion] from the field list and then click OK to close the dialog. After making this modification to the detail group, hover over the SalesAmount field and click the field list icon. Reselect the SalesAmount field from the drop-down list. This will apply the SUM aggregate function
|144||Error in Text|
Instead of inserting the total row for the SalesTerritoryRegion field (shown in Figure 6-19,) right-click the CalendarYear textbox and then follow the same instructions to insert a new row for the total.
|572, 573||Error in Text|
On page 572, the function declaration in the C# code uses the wrong function name. It is:
It should be:
On Pg 573, just below the VB code sample, theres a reference to the same function name in the paragraph, but its misspelled: REGetParemeter (its not pluralized like the code).