Course Outline
I. Introduction to Reporting Services
- Overview of Reporting Services
- The Role of Reporting Services
- Key Features of Reporting Services
- Configuring a Reporting Services Architecture
Lab 1
- Discussing the need of reporting services
- Designing the reporting services architecture
II. Installing and Initial Configuration of Reporting Services
- Installing Reporting Services
- Installation Requirements
- Installation Scenarios
- Exploring the Reporting Services Tools
- Developer Tools
- Management Tools
Lab 2
- Installing Reporting Services
- Working with the Report Designer
- Working with Report Manager
- Exploring the other Tools
III. Authoring Reports
- Basics of Report Authoring
- Configuring Data Sources
- Creating Tabular Reports
- Summarizing Data
- Applying Basic Formatting
- Enhanced Reports
- Navigation controls
- Interactive Navigation
- Displaying Data
Lab 3
- Creating a Basic Table Report
- Formatting the Report
- Adding Calculated Values
- Working with Document Maps
- Using Dynamic Visibility
- Creating Actions
- Using a List Data Region
IV. Working With Data Sets
- Defining Report Data
- Connecting to a Data Source
- Querying a Data Source
- Use of Alternate Data Sources
- Interacting with a Data Set using Parameters
- Using Parameter Filters
- Using Parameter Lists
- Best Practices for using Static and Dynamic Parameter Lists
- Defining Report Data
Lab 4
- Restricting Query Results
- Filtering Report Data
- Dynamic Parameter Lists
- Parameters with Stored procedures
- Displaying all Categories in a parameter list
V. Report models
- Understanding When to Use Report Models
- Creating a Report Model
- Report Model Objects and Concepts
- Report Model Options
- Working with Model Designer
- Working with Report Builder
- Defining Report Builder
- Working with folders and Entities
- Sorting and Grouping Data
- Filtering Data
- Viewing a Report
Lab 5
- Creating a Report Model
- Creating Different Reports
- Using Report Builder to Create a Report
VI. Executing and Publishing Reports
- Executing Reports
- Process Flow
- Reports on Demand
- Session Caching
- Linked Reports
- Publishing Reports
- Publish With Report Designer
- Publish With Report Manager
- Updating Data Sources, Reports, and Report Properties
- Cached instances
- Executing
- Using Query Parameters
- Using Filters with Cached Instances
- Snapshots and Report History
- Executing Snapshot Reports
- Using Query Parameters
- Using Filters
- Configuring Snapshots
- Using Report History
- Configuring Report History
Lab 6
- Publishing Reports
- Executing Reports
- Creating a Cached Instance
- Using a Snapshot and Report History
VII. Report Services Subscriptions
- Defining Report Subscriptions
- Creating Report Subscriptions
- Standard Subscriptions
- Data-Driven Subscriptions
- Managing Report Subscriptions
- Using Report Manager
- Controlling Report Distribution
- Subscription and Delivery Availability
- Monitoring Availability
Lab 7
- Creating a Subscription Scenario
- Using a Data Driven Subscription
- Working with a Standard Subscription
VIII. Reporting Services Management
- Server Administration
- Configuration Files
- Configuration Manager
- Service Accounts
- Security
- Authorization Model
- Assigning Roles
- Securing Items
- System Level Role Definitions
- Secure the System
- Performance
- Trace Files
- Logging Report Execution
- Performance Counters
- Timeouts
- Suspending Jobs
- Administrating Databases
- Database Storage
- Backup and Restore Strategy
Lab 8
- Using the Reporting Services Manager
- Securing the Reporting Server and Site
- Securing Items
|
