About this course:

This course will focus on the teaching of the basics of report writing with Microsoft® SQL Server® Report Designer and SSRS to the students. This is a 2-day course with intermediate difficulty level. The course will be focused upon report creation. This will be done by connecting to a database and tweaking the data for presentation that would include making parameter reports and list reports, adding complicated expressions, images and sub-reports, drilldown and drill-through functionality, and sparklines, data bars, and indicators, all of these to the reports. Report Designer is available for all supported versions of Microsoft® SQL Server®.

Audience:

The course has been designed for two groups of audiences:

The primary or main audience, for which this course is intended for, are those are new to reporting with Microsoft® SQL Server® Report Designer and SSRS. It is also for those people who are shifting from some other reporting software application, and people who are already Report Builder and SSRS report authors.

The secondary audience for this course is of those who are using Report Builder (SSRS).

People who are taking this course can be anyone from business analysts, programmer analysts, data analysts, database administrators, to IT professionals. It is for those people who may or may not have any experience with Microsoft® SQL Server® Report Builder and SSRS, programming (Visual Basic), and/or Transact-Structured Query Language (T-SQL).

Learning objectives:

The course has the following learning objectives:

• Making parameter reports
• Making list reports
• Inserting complex expressions in the reports
• Inserting images and sub-reports
• Inserting drilldown and drill-through functionality
• Inserting sparklines, data bars, and indicators