What you'll 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
This is a comprehensive tutorial that guides you, step by step, on how to create reports using SSRS.
Neither the Report Builder nor the Report Wizard is covered in this course.
The lessons in this course are designed so that each teaches only one major topic at a time. In each lesson, we will build a complete report from start to finish, and along the way, there will be several minor topics introduced, contributing to that major topic.
There will be some lessons that will take reports from a previous lesson and build on them accordingly for those topics that are being introduced.