Day 1
Day 1
Module 1 ? Introduction to SQL Server Reporting Services
- What is SSRS and features overview
- SSRS Architecture and components
- Installation and Setup
- BIDS environment and the Report Designer IDE
- Report Development Lifecycle
- Lab ? Setting up your Reporting Development environment
Module 2 ? Introduction to Reporting Services Report Designer
- Reporting Services Data Sources
- Report Designer Table Control
- Report Designer List Control
- Report Designer Matrix Control
- Report Designer Image Control
- Report Designer Wizard
- LAB ? Building a report with the SSRS Wizard
Module 3 ? Designing and Developing Reports with Reporting Services
- Creating and utilizing data sources
- Developing reports using the Table control
- Developing reports using the List Control
- Developing reports using the Matrix Control
- Utilizing the Image control in Reporting Services
- LAB ? Designing and developing reports using the Table, List, and
Matrix controls
Module 4 ? Report Deployment
- Introduction to Report Manager portal
- Report Deployment in Reporting Services
- The ReportServer database
- Configuring your environment to deploy reports
- LAB ? Deploying Reports to the Report Server
Module 5 ? Report Builder
- Introduction to Report Builder
- Report Builder Models
- Ad-Hoc Reporting with Report Builder
- Adding Security with Report Builder
- LAB ? Building a Report Builder Model
Day 2
Group Lab 1 ? Creating a basic End-to-End Reporting Services Report
Module 6 ? Designing and Developing Reports utilizing the Chart Controls
- Introduction to Charting Controls in Reporting Services
- Data Architecture for Chart control development
- Configuration of Charting controls in Reporting Services
- LAB ? Designing and developing reports using charts
Module 7 ? Sub-reports, Drill-down, Drill-through and Navigation
- Introduction to Sub-reports in Reporting Services
- Creating and configuring sub-reports
- Creating and configuring drill-down and drill-through reports
- Configuring report navigation
- LAB ? Creating a report using sub-reports, drill-through, and
navigation
Module 8 ? Grouping and Sorting
- Introduction to Grouping in Reporting Services
- Data architecture for grouping in table controls
- Configuring grouping in a table control
- Interactive sorting in reporting services
- Configuring sorting in a report
- LAB ? Create a report using grouping and sorting
Module 9? Parameters
- Using Parameters in Reporting Services
- Default, Lookup, and Multi-value parameters
- Dynamic cascading parameters
- Understanding and configuring the various parameter properties
- LAB ? Creating a parameter-driven report
Module 10 ? Expressions, Functions, and Custom Code
- Introduction to expression builder in reporting services
- Using expressions to create dynamic reports
- Using reporting services functions with expressions
- Extending reports with custom code
- LAB ? Create a dynamic report using expressions and custom code
Day 3
Group Lab 2 ? Creating an advanced End-to-End Reporting Services Report
Module 11 ? Reporting from Analysis Services Cubes
- Introduction to Analysis Services Cube data
- Connecting to Analysis Services from Reporting Services
- Creating Reports on Analysis Services Cubes
- LAB ? Building a report from Analysis Services cubes
Module 12 - Report Development Data Architecture
- Requirements gathering for Report Development
- Data Architecture in report development
- Staging data techniques for reports consumption
- Report View control for Windows and Web applications
- LAB ? Building and loading a staging architecture based on report
requirements
Module 13 ? Report Management
- Configuring reports in Report Manager
- Configuring Report Parameters in Report Manager
- Configuring Data Sources in Report Manager
- Configuring Security in Report Manager
- Running Reports in Report Manager
- LAB - Configuring and running reports in Report Manager
Module 14 ? Report Subscriptions
- Introduction to Report Subscriptions in Reporting Services
- Standard Subscriptions
- Data-Driven Subscriptions
- Report Delivery Options
- Managing Subscriptions in Report Manager
- LAB ? Configuring Standard and Data-Driven Subscriptions
Day 4
Module 15 ? SQL Server 2008 Reporting Services
- Explore new features in SSRS 2008
- New Controls in SSRS 2008
- Creating reports in SSRS 2008
- LAB ? Creating a report using the new Tablix control
Group Project ? Create a Dashboard Report
Day 4 will consist of an all day project where the students will be given a
set of basic requirements, transform those into a polished set of full
requirements with the aid of the instructor. Then the students will create,
deploy and configure (in Report Manager) and run the successfully created
report. The report will contain all the controls and techniques covered in
the class through an entire phase of the report lifecycle. The report will
pull data from a staging environment created and loaded by the student and
will utilize parameters, grouping, sorting, sub-reports, drill-down,
drill-through, expressions, table control, list control, matrix control,
images, charts & graphs, and subscriptions.