Information Technology
55128 Writing Reports with Report Builder and SSRS Level 2
In this course, students will continue their learning on the foundations of report writing with Microsoft® SQL Server® Report Builder and SSRS. The focus will be on report creation by connecting to a database and manipulating the data.
2 Days
16 Hrs
6 Lessons
Course Objectives
After completing this course, students will be able to:
- Create parameter reports. Create list reports. Format reports with complex expressions. Add images and subreports. Add drilldown and drillthrough functionality. Add sparklines, data bars, and indicators.
Agenda
- Parameterized Reporting
- Create Report Parameters
- Modify Report Parameters
- Provide Default Parameter Values
- Provide Available Values for Parameters
- Lab: Creating Parameterized Reports
- Introducing the List Data Region
- Create Reports Using List Data Regions
- Modify Reports Which Use List Data Regions
- Lab: Creating List Reports
- Formatting Reports
- Top N Reports
- Running Values
- Lab: Enhancing Reports with Complex Expressions
- Add Images to Reports
- Retrieve Images from a Database
- Introducing SSRS (SQL Server Reporting Services) Report Server
- Add Subreports to Reports
- Lab: Working With Images and Subreports
- Add and Configure Drilldown Reporting
- Add and Configure Drillthrough Reporting
- Lab: Add Drilldown and Drillthrough Functionality to Reports
- Sparklines
- Data Bars
- Indicators
- Lab: Adding Sparklines, Data Bars, and Indicators to Reports
FREE
Interested in course?
Course Type: Instructor Led