The Practical Guide to SQL Server Reporting Services (SSRS)

Learn step by step how to build professional SSRS reports with Visual Studio 2019 and SQL Server 2019. Novice to Pro.

Created by: Colin Rose
Computer Programmer / DBA

What Will I Learn?

• How to create dynamic and visually appealing reports using Visual Studio 2019 and SQL Server 2019.
• How to install reporting services and configure the report server
• A little bit of database administration
• How to use SQL Server Management Studio to construct your queries
• How to apply basic and advanced features of SSRS
• Some best practices in report authoring
• How to create views and stored procedures
• How to apply appropriate formatting to enhance the readability of your reports
• How to export your reports
• How to deploy and manage your reports
• How to set user permissions on your reports
• How to set up subscriptions on your reports
• How to handle errors you may encounter

Requirements

• You will need a basic understanding of relational database management systems and structured query language (SQL)

Target audience

• The Information Systems professional who is tasked with providing management reporting for their organization
• Software developers who are creating and maintaining applications, and who will need to create reports based on such applications
• Database developers and administrators
• Individuals with experience using relational databases such Microsoft SQL Server, MySQL or Oracle, who would like to expand their knowledge into reporting
• Those who are curious about reporting, with the drive to learn a new skill that will benefit them now or in the future