DescriptionSQL Server Reporting Services is the customizable reporting solution for report designers and programmers. This hands-on guide will get you up to speed quickly so you can design, deploy, manage, and even customize reporting solutions. You can create powerful reports without programming knowledge and extend reporting solutions using VB, C#, and ASP.NET.
Packed with detailed examples of building reports, designing report solutions, and developing deployment strategies for interacting with various platforms, this book prepares you to take full advantage of this revolutionary tool. Plus, you'll learn how to extend practically every feature of Reporting Services by implementing your own security architecture or adding custom data access.
What you will learn from this book
- Details of programming reports and report scripting
- Advanced report design, including drill-down reports, nested lists, drill-through, links, and dynamic content
- High-level strategies for business and support systems
- Rendering reports using .NET code, .NET IO namespace classes, and URL rendering deployment strategies to handle hardware, software, and platform considerations, licensing issues, and scaling options
- How to design reports for mobile services
- Various tools used to define data sources and semantic metadata models
- How to use parameters and expressions to define creative report solutions
- Advanced object-oriented programming techniques, with examples in C# and VB 2005.
Who this book is for
This book is for report designers, developers, administrators, and business professionals interested in learning the advanced functionality, report server administration, and security issues of SQL Server 2005 Reporting Services.
Wrox Professional guides are planned and written by working programmers to meet the real-world needs of programmers, developers, and IT professionals. Focused and relevant, they address the issues technology professionals face every day. They provide examples, practical solutions, and expert education in new technologies, all designed to help programmers do a better job.
Part One: Getting Started.
Chapter 1: What Can You Do with Reporting Services?
Chapter 2: Introduction to Microsoft SQL Server Reporting Services 2005.
Chapter 3: Reporting Services Architecture.
Part Two: Report Design.
Chapter 4: Basic Report Design.
Chapter 5: Designing Data Access.
Chapter 6: Advanced Report Design.
Chapter 7: Report Solution Patterns and Recipes.
Part Three: Enabling End User Reporting with Report Builder.
Chapter 8: Reporting Services Report Models.
Chapter 9: Report Builder.
Part Four: Administering Reporting Services.
Chapter 10: Report Management.
Chapter 11: Report Server Administration.
Part Five: Reporting Services Integration and the Reporting Services Web Services.
Chapter 12: Integrating Reporting Services into Custom Applications.
Chapter 13: Extending Reporting Services.
Appendix A:Migrating Access Reports.
Appendix B: Reporting Services Object Model.
Appendix C: Transact SQL Command Syntax Reference.
Appendix D: Transact SQL System Variables and Functions.
|Download Content,The content for this title has been posted and may be accessed via http://www.wrox.com/WileyCDA/WroxTitle/productCd-0764584979,descCd-download_code.html||3/22/06|
|9||Error in Punctuation,Third line under User-Designed Reports section:|
display, print. or save to a file.
display, print, or save to a file.
|15||Error in Text,under Portal Integration section:|
|31-32||Error in Text,On page 31 - 32 there is a table called Report Server. This table is missing check marks in certain columns. In the book on page 31, it says the table can be found at:|
which redirects you to:
At this URL you can find the table in the book and it shows you what check marks are missing from the table.
|3||47||Error in Text,On the Delivery paragraph, text reads:|
Push delivery on the other hand...
Pull delivery on the other hand...
|50||Error in Reference,source|
|62||Error in Code name,Configuration|
|64||Error in Code name,ReportServer|
|4||82||Error in Text,The SubCategory field should be added to the Group box. All other fields are added to the Details box.||05/08/2006|
|4||114||Error in Text,Currency example reads:|
|118||Error in Figure 4-58,Figure 4-58 is incorrect. In both rows with the UK Locale:|
|134||Error in Code,The last line on the page shows parameter name @ListPriceMax.|
Should match Figure 5-11 that shows the parameter name to be @MaxListPrice.
|139||Error in Code,The CountryRegion table should be prefixed with the Person Schema to read Person.CountryRegion in the FROM clause.|
The code had not been updated correctly from the earlier version of the AdventureWorks sample database before SQL Server 2005 schema references were required.
|141||Error In text,Text under Figure 5-18 |
The CountryCode parameter...
The CountryRegionCode parameter...
|5||143||Error in Text,The text below figure 5-21: |
as shown in Figure 5-22
as shown in Figure 5-21
|150||Error in Figure,Figure 5-30: CREATE PROCEDURE dbo.Get_StoresByLocation should be: CREATE PROCEDURE sp.GetStoresByLocation.||05/23/07|
|153||Correction, In Figure 5-33, I found the example worked only if the CInt function was used in the Value column and NOT in the Expression column. Also, the text just above the figure needs to be corrected to correspond with the correction to the figure.||12/20/2007|
|6||213||Error in Text,Text reads:|
In the Advanced Textbox Properties dialog box
In the Navigation tab of the Textbox Properties dialog
|6||233||Error in Text,Text reads:|
the trend increases back to front
the trend decreases back to front or the trend increases front to back
|12||492||Error in Text,At the bottom of page, the text reads:|
URL for accessing your Customer Product Sales Pivot report
URL for accessing your Customer Product List by Category report
|12||496||Error in Text,At the bottom of page, the text reads:|
the Customer Product Sales Pivot report
the Customer Product List by Category report
|503||Error in Text,The WebReference: |
|Appendix C||624||Error in Code, Compute by paragraph is repeating information from Order By paragraph.|
The corrected code should read:
SELECT ProductID, SalesOrderID, OrderQty
ORDER BY ProductID, SalesOrderID
|Appendix D||639||Error in Text,'ID should read:|
|Appendix D||652||Error in Text,Text reads:|