Module 1: Introduction to Microsoft SQL Server Reporting Services
Lessons
- Overview of SQL Server Reporting ServicesInstalling Reporting ServicesReporting Services ToolsLab 1: Using Reporting Services ToolsExercise 1: Exploring Report DesignerExercise 2: Exploring Report Manager
After completing this module, students will be able to:
- Describe the features of SQL Server Reporting Services
- Install Reporting Services
- Describe the Reporting Services tools
Module 2: Authoring Basic Reports
Lessons
- Creating a Basic Table ReportFormatting Report PagesCalculating ValuesLab 2: Creating a Simple ReportExercise 1: Creating a Basic Table ReportExercise 2: Formatting Report PagesExercise 3: Adding Calculated Values
After completing this module, students will be able to:
- Create a basic table report
- Format report pages
- Calculate values for a report
Module 3: Enhancing Basic Reports
Lessons
- Interactive NavigationDisplaying DataLab 3: Enhancing a ReportExercise 1: Using Dynamic VisibilityExercise 2: Using Document MapsExercise 3: Initiating ActionsExercise 4: Using a List Data Region
After completing this module, students will be able to:
- Create reports with interactive navigation
- Display data in various formats
Module 4: Manipulating Data Sets
Lessons
- Defining Report DataUsing Parameters and FiltersUsing Parameter ListsLab 4: Manipulating Data SetsExercise 1: Using parameters to restrict query resultsExercise 2: Using parameters to filter report dataExercise 3: Creating dynamic parameter listsExercise 4: Using parameters with a stored procedure. If Time Permits: Displaying all categories in a parameter list
After completing this module, students will be able to:
- Define report data
- Use parameters and filters
- Use parameter lists
Module 5: Using Report Models
Lessons
- Creating Report Models
- UsingReport Builder
Lab 5: Working with Report Models
- Creating a Report Model
- Using Report Builder to Create a Report
After completing this module, students will be able to:
- Create Report Models
- Use Report Builder
Module 6: Publishing and Executing Reports
Lessons
- Publishing Reports
- Executing Reports
- Creating Cached Instances
- Creating Snapshots and Report History
Lab 6: Publishing and Executing Reports
- Publishing Reports
- Executing a Report on Demand
- Configuring and Viewing a Cached Report
- Configuring and Viewing a Snapshot Report
After completing this module, students will be able to:
- Publish reports
- Execute reports
- Create cached instances
- Create snapshots and report history
Module 7: Using Subscriptions to Distribute Reports
Lessons
- Introduction to Report Subscriptions
- Creating Report Subscriptions
- Managing Report Subscriptions
Lab 7: Implementing Subscriptions
- Creating a Standard Subscription
- Creating a Data-Driven Subscription
After completing this module, students will be able to:
- Describe report subscriptions
- Create report subscriptions
- Manage report subscriptions
Module 8: Administering Reporting Services
Lessons
- Server Administration
- Performance and Reliability Monitoring
- Administering Report Server Databases
- Security Administration
Lab 8: Administering Reporting Services
- Using Reporting Services Configuration Manager
- Securing a Reporting Services Site
- Securing Items
After completing this module, students will be able to:
- Administer the reporting server
- Monitor performance and reliability
- Administer the Report Server databases
- Administer security
Module 9: Programming Reporting Services
Lessons
- Querying for Server Information Using a Web Service
- Automating Report Management
- Rendering Reports
- Creating Custom Code
Lab 9: Programming Reporting Services
- Using URL Access to Display a Report
- Building a Reporting Services Web Service Client
- Using the Report Viewer Control
After completing this module, students will be able to:
- Query server information by using a Web service
- Automate report management
- Render reports
- Create custom code
|
Printable version
