How would you deploy your report using BIDS/SSDT - SSRS Interview Questions & Answers

There are different ways to deploy or publish reports to Reporting Server. In this post/video we will learn how to deploy Data Sources, Shared Data-Set or Report/s by using BIDS/SSDT.

If you are an SSRS developer and you have already created SSRS Project with reports by using BIDS/SSDT, then you will be straight forward deploying report.

If you are a DBA, you need to get the Solution with SSRS Project and open by using BIDS/SSDT to deploy from there. If there is no solution or project provided to you and you have only RDLs (Reports), you can create empty SSRS Project in BIDS/SSDT and then right click on Reports Tab and then add existing Items and choose the report/s you would like to add to Project.

Once you have the project ready with report. You need Information where you need to deploy the report

You need Report Server URL
You need to know the Folder Name in which you would like to deploy your report/s
If you need to deploy Data Sources and Shared Data-Sets, you need to provide the Folder Names as well.

Note: To deploy/Publish reports to Report Server, you need permission on Report Server.

Check out our website for Different Technology tutorials and interview questions
such as SQL Server Reporting Services(SSRS) Tutorial
SQL Server Integration Services(SSIS) Tutorial
SQL Server DBA Tutorial