Flylib.com
Microsoft SQL Server 2005 Reporting Services
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
Microsoft SQL Server 2005 Reporting Services
ISBN: 0672327996
EAN: 2147483647
Year: 2004
Pages: 254
Authors:
Michael Lisin
,
Jim Joseph
BUY ON AMAZON
Beginners Guide to DarkBASIC Game Programming (Premier Press Game Development)
Basic Commands, Variables, and Data Types
Characters, Strings, and Text Output
Looping Commands
Number Crunching Mathematical and Relational Operators and Commands
Playing Some Tunes CD Audio, MIDI and MP3 Music
Java I/O
Character Data
Buffers and Channels
Byte Arrays
Communicating Between Threads Using Piped Streams
Selectors
CISSP Exam Cram 2
Assessing Exam Readiness
Requirements for New Site Locations
Access-Control Systems and Methodology
System Architecture and Models
Answers to Exam Prep Questions
Visual C# 2005 How to Program (2nd Edition)
Using Help
Example: Divide by Zero Without Exception Handling
PictureBoxes
Multithreading with GUIs
Connectionless Client/Server Interaction with Datagrams
GDI+ Programming with C#
A Simple Text Editor
The Graphics Class and Transformation
Double Buffering and Flicker-Free Drawing
Understanding the SetStyle Method
Cautions for Using GDI in Managed Code
Digital Character Animation 3 (No. 3)
Approaching Design as an Artist
Understanding Motion
Transitions
Chapter Eight. Animal Motion
Characters and Story
flylib.com © 2008-2017.
If you may any questions please contact us: flylib@qtcs.net
Privacy policy
This website uses cookies. Click
here
to find out more.
Accept cookies