|
 Course
Outline
Introduction to Microsoft SQL Server Reporting Services
- Introduction to Microsoft SQL Server Reporting Services
- Reporting Scenarios
- Reporting User Communities
- The Enterprise Reporting Life Cycle
- Authoring
- Management
- Access and Delivery
- Reporting Services Components
- Authoring Components
- Management Components
- Access and Delivery Components
- Installing Reporting Services
- Considering Deployment Options
- Choosing a Reporting Services Edition
- Planning a Site Configuration
- Deciding Naming Conventions
- Preparing for Installation
- Reviewing Operating System Requirements
- Reviewing Software Requirements
- Reviewing Configuration Prerequisites
- Creating Reporting Services Credentials
- Installing Reporting Services
- How to Install Reporting Services by Using Setup
- Launching Setup
- Choosing the Components
- Selecting the Service Account
- Specifying the Report Server and Report Manager Virtual Roots
- Specifying the Report Server Database
- Specifying Report Delivery Options
- Choosing a Samples Location
- Selecting Licensing Options
- Verifying the Installation
- Build Your First Report
- Authoring a Report
- How to Prepare a Report
- Starting a New Report
- Connecting to a Data Source
- Getting Data for the Report
- How to Design a Report
- Structuring Data in the Report
- Placing Data in the Report Structure
- Applying a Style Template
- How to Complete the Wizard
- Finishing the Report Wizard
- How to Publish a Report
- Checking the Report Layout
- Correcting Report Layout Issues
- Publishing a Report
- Managing a Report
- How to Change Report Properties
- Reviewing Report Properties
- Changing Report Properties
- How to Change Execution Properties
- Reviewing Execution Properties
- Changing Data Sources Properties
- Changing Execution Properties
- Accessing a Report
- How to Explore a Report
- Displaying a Report
- Searching a Report
- How to Export a Report
- Exporting a Report
Authoring Reports
- Developing Basic Reports
- Understanding a Report Definition File
- Preparing a Report by Using Report Designer
- Structuring a Report by Using Report Designer
- Formatting a Report by Using Report Designer
- Working with Expressions
- Using Expressions to Calculate Values
- Using Aggregate Functions
- Using Expressions to Change an Object’s Behavior
- Organizing Data in Reports
- Understanding Data Regions
- Using a Matrix
- Using a Chart
- Using a List
- Building Advanced Reports
- Using Parameters to Change Report Data
- Linking Information with Interactive Features
- Working with Hierarchical Data
Managing the Report Server
- Managing Content
- Publishing Reports
- Organizing Content
- Using Properties to Manage Report Content
- Managing Report Execution
- Managing Security
- Using Report Server Security
- Applying Data Security
- Managing Server Components
- Configuring Reporting Services
- Managing the Report Server
- Administering Reporting Services Databases
Delivering Reports
- Accessing Reports
- Finding and Viewing Reports
- Saving Reports for Future Reference
- Rendering Reports
- Comparing Rendering Formats
- Rendering for Online Viewing
- Rendering for Document Management
- Rendering for Data Exchange
- Managing Subscriptions
- Creating a Standard Subscription
- Creating a Data-Driven Subscription
- Managing Subscriptions
Hands-on
Assignments
The key concepts taught will be immediately followed up by the
hands-on assignments in the lab to facilitate ease of understanding.
It will be 60% Lecture/40% Lab.
Back to Course Description Onsite Training
Class Schedule
Registration
|
