Simple play icon Course

Building Your First SSRS Report

by Robert Cain

In this course you'll quickly learn to create professional-looking reports for SQL Server Reporting Services using Microsoft Visual Studio.

What you'll learn

Microsoft's SQL Server Reporting Services (SSRS) allows users to create business-critical reports on a scalable, server-based platform. In this course, Building Your First SSRS Report, you will gain the ability to create professional-looking reports for SQL Server Reporting Services. First, you will learn to create a report using the Report Wizard. Next, you will discover how to generate a report manually, giving you more fine-tuned control over the report creation process. In addition, you will learn to add professional touches such as charts and parameters. Finally, you will explore how to deploy your reports to the SSRS Report Portal for your entire organization to use. When you’re finished with this course, you will have the skills and knowledge of SQL Server Reporting Services needed to create great looking reports. Software required: this course uses SQL Server 2017 Developer Edition (free) and Visual Studio 2017 Community Edition. The techniques taught in the course are compatible with older versions of SQL Server and Visual Studio.

Course FAQ

What is SSRS?

SQL Server Reporting Services (SRSS) is a server-based report generating software system from Microsoft. SSRS is primarily used to prepare and deliver a variety of interactive and printable reports.

Who is this course for?

This course if for anyone wants wants to learn SSRS.

What will I learn in this SSRS tutorial?

In this course, you will learn how to build reports using the built-in report wizard, create ports manually, format reports, use parameters, and deploy reports.

Are there any prerequisites for this SSRS tutorial?

There are no prerequisites for this course. No prior SSRS knowledge is required.

What software is required?

Software required for this course is SQL Server 2017. The techniques taught in this course are also compatible with some older versions of SQL Server and Visual Studio.

About the author

Robert C. Cain ( is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is a course author for Pluralsight, team member at Linchpin People, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQL Saturdays. Robert has over 25 years' experience in the IT industry, working in a variety of fields including manufacturing, insurance, teleco... more

Ready to upskill? Get started