Microsoft SQL
Server - Reporting Services
Who should attend:
Reporting Services provides an elegant solution for the production manager,
sales director and CEO.
You do not need to be a programmer to do this course, however module 7 and 8
include some simple VB expressions that can spice up your report presentation,
however not required to create great, useful reports.
If you know SQL you will get more out of the course, but if you are new to it,
you will still find the course useful and maybe a good reason to do an SQL
course.
Part I
Getting Started
1. Let's start at the very beginning
Starting Business Intelligence
The need to share
Possible solutions
Microsoft Reporting Services
Report Authoring Architecture
The Business Intelligence Project Type
Report Structure
Report Designer
Standalone Report Builder
Report-Serving Architecture
Report Server
Report Delivery
Driving In
2. Putting the Pieces in Place: Installing
Reporting Services
Preparing for the Installation
The parts of the Whole
Editions of Reporting Services
Types of Reporting Services Installations
Installation Requirements
Other Installation Considerations
The Installation Process
The SQL Server 2008 Installation
The Reporting Services Configuration Manager
Common Installation Issues
Administrative Rights
Server Components not shown on the feature selection screen
Installation Error 2755
Reporting Services and IIS on the same server
The Repair utility and Installation Log File
Spending Some time in Basic Training
Part II
Report Authoring
DB 101: Database Basics
Database Structure
Getting Organized
Retrieving Data
Galactic Delivery Services
Company Background
Querying Data
The SELECT Query
On the Reports
A Visit to Emerald City: The Report Wizard
Obtaining the Galactic Database
Your First Report
The Customer List Report
An Interactive Table Report
The Customer-Invoice Report
Creating Matrix Reports
The Invoice Batch Number Report
Report Parameters
The Parameterized Invoice -Batch Number Report
Flying Solo
Removing the Training Wheels : Building
Basic Reports
Riding Down Familiar Roads
The Transport List Report
The Tablix and Data Regions
The Repair Count by Type Report
New Territory
The Transport Information Sheet
Getting Graphical
6. Graphic
Expression: Using Charts, Images, and Gauges
Chat Your Course
The Deliveries versus Lost packages Chart
The Fuel Price Chart
The Fuel Price Chart, Version 2
The Business Type Distribution Chart
The Days in Maintenance Chart
Gauging the Results
The Digital Dashboard
Image is Everything
Conference Nametags
Conference Place Cards
The Rate Sheet Report
Building Higher
7. Kicking It Up a Notch: Intermediate
Reporting
Never having to Say "I'm Sorry"
The Report Template
Handling Errors in Reports
The Employee Time Report
Data Caching During Preview
The Employee List Report
The Employee Mailing Labels Report
The Overtime Report
The Revised Employee Time Report
Under the Hood
Viewing the RDL
Practicing Safe Source
Using Visual SourceSafe
Advance, Never Retreat
8. Beyond Wow: Advanced Reporting
Speaking in Code
The Delivery Status Report
The Lost Delivery Report
The Customer List Report - Revisited
Payroll Checks
The Weather Report
The Delivery Analysis Report
Reports Within Reports
The Employee Evaluation Report
The Invoice Report
Interacting with Reports
The Invoice Front-End Report
The Transport Monitor Report
A Conversion Experience
The Paid Invoices Report
What's Next
9. A Leading
Exporter: Exporter Reports to Other Rendering Formats
A Report in Any Other Format Would
Look as Good
Exporting and Printing a Report
Presentation Formats
TIFF Image Presentation Format
Adobe PDF Presentation Format
Web Archive Presentation Format
Excel Presentation Format
Word Presentation Format
Printed Presentation Format
Data Exchange Formats
Comma=Separated Values (CSV) Data Exchange Format
XML Data Exchange Format
Call the Manager
Part 111 Report
Serving
10. How Did We Ever
Manage Without You? The Report Manager
Folders
The Report Manager
Moving Reports and Supporting Files to the Report Server
Deploying Reports Using the Report Designer
Uploading Reports Using Report Manager
Uploading Other Items Using Report Manager
Uploading Reports Using .NET Assemblies
Modifying Reports from the Report Server
Managing Items in Folders
Moving Items Between Folders
Deleting a Folder
Renaming a Folder
Seek and Ye Shall Find: Search and Find Functions
Searching for a Report
Finding Text Within a Report
Printing from Report Manager
Printing Options
Managing Reports on the Report Server
Security
Roles
Linked Reports
Creating a Linked Report
Delivering the Goods
11. Delivering the Goods:
Report Delivery
Caching In
Report Caching
Enabling Report Caching
Execution Snapshots
Enabling Execution Snapshots
Report History
Enabling Report History
Managing Report History Snapshots
Updating Report Definitions and Report History
Subscriptions
Standard Subscriptions
Managing Your Subscriptions
Data-Driven Subscriptions
Site Settings
The General Site Settings Page
Other Pages Accessed from the Site Settings page
Managing Reporting Services Through the SQL Server Management
Studio
Additional Settings
A Sense of Style
The Reporting Services Style Sheet
Building On
12. Extending Outside the
Box: Customizing Reporting Services
Using
Reporting Services Without the Report Manager
URL Access
Web Service Access
The Report Viewer Control
SharePoint Web Parts
Reporting Services Utilities
Custom Security
Authentication and Authorization
Issues with Custom Security
Creating a Custom Security Extension
Deploying a Custom Security Extension
Using the Custom Security Extension
Other Extensions
Best Practices
Report-Authoring Practices
Report Deployment Practices
Where Do We Go from Here?
Part IV
Appendixes
A Report Item Reference
Report Objects
Layout Areas
Data Regions
Report Items
Property Reference
Properties
B Web Service Interface
Reference
Reporting Services Web Services
Creating a Web Reference
Credentials
Compatibility
Report Execution 2005 Properties
Report Execution 2005 Methods
Report Service 2005 Properties
Report Service 2006
Report Service 2005 and Report Execution 2005 Web Service
Classes
C Ad Hoc Reporting
The Report Model
Creating a Report Model
Creating Reports within the Report Builder
Report Builder basics
Creating a Table Layout Report
Creating a Matrix Layout Report
Creating a Chart Layout Report
Give a try
