SQL Server Reporting Services (SSRS)

Course Content

1. Getting Started with SSRS
   • What is SSRS?
   • Installing SQL Server with Reporting Services
   • Report Design Environments
   • Introduction to Visual Studio
2. Retrieving Data for Reports
   • Solutions and Projects
   • Create a New Project
   • The Elements of a Report
   • Data Sources and Datasets
   • Creating a Report
3. Designing Report Layout
   • Report Design Elements
   • Adding a Table to display data
   • Adding Page Header and Footer
   • Formatting the Table
4. Expressions and Functions
   • Introduction of Expressions
   • Develop Expressions with a Built-in Field
   • Using Function in an Expression
   • Using IIF function
   • Using SWITCH function
5. Making Reports Dynamic with Parameters
   • Using Report Parameters
   • Parameter Lists
   • Create a Dynamic Parameter List
   • Default Parameters
6. Creating Drill-down Reports
   • Introduction to Drill-down Reports
   • Create a Drill-down Report
7. Creating Multi-level Reports
   • Introduction to Multi-level Reports
   • Create a Multi-level Report
   • Adding Subtotals and Totals
   • Making Expandable/Collapsible Groups
8. Creating Matrix Reports
   • Introduction of Matrix Reports
   • Aggregate Data
   • Creating a Matrix Report
   • Grouping in a Matrix Report
9. Creating Charts
   • Adding a Bar Chart
   • Creating a Pie Chart
10. Using Indicators
    • Introduction to Indicators
    • Adding an Indicator Column

Course Dates, Prices & Enrolment

Price Calculator & Booking Request Form

Calculate prices for Corporate, 1-on-1 or group training and request a booking.

Do you have a special training requirement or unable to find any suitable training date? Please complete and submit the booking request form, if you want to:

The price person is less when you book a course for more people. You can find the price per person and the total cost by changing the values of the training hours and the number of people below:

Study Path

Career Path

Participant Reviews