Add a custom report to SSMS

Maybe some of you don't know this, but to view Report Definition Language reports (RDL) , you aren't forced to use SQL Server Reporting Services and a report server running on the machine. With the latest version of SSMS you are able to view any report, just have in mind 2 things when creating your report to be able to use it on SSMS: Use an embedded Dataset for your report and point the server name to (local) Add the database name to your objects if you want a specific db, otherwise, SSMS will use the current db or the master as default. You can create RDL reports (among other projects) with the free tool SQL Server Data Tools (SSDT) who is the replacement for the old Business Development Integration Studio(BIDS). Once you have your report created, it is just matter of importing it to SSMS to use it. I will show you how to do it. Add the report to SSMS For this example I am using one of my open source reports for server monitoring . First, connect to your ser