
About this Course
Syllabus
About this Training
Microsoft SQL Server Reporting Services is a SQL Server component that facilitates the ability of building flexible, powerful reports. These reports can be delivered in a range of formats, and be presented using web or Windows-based applications.
In this course, you learn how to use the SSRS to extract business intelligence from your data, how to produce compelling reports with enhanced visualisation features, how to integrate parameters, filters and interactive components into reports, and also how to deploy these reports.
Audience Profile
This course is mainly intended for Database Administrators, Database Developers, Business Intelligence professionals, QA professionals, Data Analysts, and other roles responsible for developing SSRS solutions.
- Creating new reports
- Adding items to the report
- Arranging items
- Formatting items
- Saving the report
- Create a new datasource
- map report to a dataset
- create new table
- embedded datasets
- Making header rows appear in each page
- Keeping header rows visible when scrolling
- Using RowNumber
- Changing the page size
- Creating groups
- Changing the page size
- Using parameters
- Adding a parent group
- Formatting
- Nested Groups
- Creating calculated fields
- Conditional functions
- Text function
- Date functions
- Concatenating text
- Using expressions to create conditions
- Using IF and SWITCH
- Adding a Gauge to a table
- Scales
- Ranges and Pointers
- Parameter values
- Drop down list parameters
- Using nulls
- Cascading parameters
- Create new matrix
- Adding calculations
- Adding sub groups