Table of Contents

Microsoft SQL Server 2005 Reporting Services
By Michael  Lisin, Jim  Joseph
...............................................
Publisher: Sams
Pub Date: March 22, 2006
Print ISBN-10: 0-672-32799-6
Print ISBN-13: 978-0-672-32799-5
Pages: 480

Table of Contents    Index

		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