Microsoft SQL Server 2005 Reporting Services

ISBN: 0672327996
EAN: 2147483647

Year: 2004
Pages: 254

Authors: Michael Lisin, Jim Joseph

BUY ON AMAZON

Microsoft SQL Server 2005 Reporting Services
Table of Contents
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 HeaderFooter
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 DateTime Values
Standard DateTime Format Strings
Custom DateTime 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
References and Additional Reading
Appendix B. Glossary
Glossary
Appendix C. FAQ
Index
SYMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Z