SSRS Interview Questions - How would you Edit already deployed SSRS Report?

As developers we create different type of scripts, Reports and SSIS Packages etc. The best practice is to check in all the scripts, reports, SSIS Packages or any other code in version control software.

Different companies use different version control software to save the scripts and other objects. Team Foundation Server is example of Microsoft version control software.

Scenario 1: When Report is checked in Version Control Software

If you or other developer has checked in the report in TFS or any other version control software, Checkout to your local folder and follow below steps
  • Open Report by using SSDT (SQL Server Data Tools)
  • Make all required changes to report
  • Save the Report and Check-in to TFS or other version control software you are using
  • Provide the location of Report to DBA so he can deploy to Report Server. If you have Permission to deploy, go ahead and deploy from SSDT.

Scenario 2: When Report is not checked in Version Control Software

In case you have not saved the report definition in TFS or any other version control software but report is available on report Server only. You have two options

 1) Click on drop down arrow next to report, go to Edit with Report Builder. It will open your report with Report Builder. You can make changes and save back to Report Server if have permissions. I will suggest to save report definition file in TFS as well so next time you can use from there.

2) Click on drop down arrow next to report, Go to Download. Download the report to your local folder. Create a new SSRS Project in SSDT (SQL Server Data Tools) and add report to Project.
Now you can make any changes and then save. From SSDT you have the option to deploy report to Report Server if you have permissions. At this point it is good idea to save the report to TFS or any version control software and provide the location path to DBA so he/she can take report from there and deploy to Report Server.

Important Note:
In case your company is not using any version control software, then make sure you take the backups of Report Server database regularly.


  1. Equipped with a thirst for knowledge, I stumbled upon a gem of a blog offering an exhaustive exploration of the system development lifecycle. From requirements analysis to post-implementation support, each phase is meticulously documented, providing clarity and direction to developers at every step of the journey. Its rich insights and practical advice serve as a beacon for those navigating the complexities of software development, empowering them to deliver solutions of unparalleled quality and effectiveness. With this invaluable resource at my disposal, I'm poised to embark on projects with newfound confidence and expertise.

  2. Hi all! Many people are thinking about additional income, and in search of employment, they come across the Shiftsmart online platform that can provide this. On this platform, a job seeker can easily find vacancies from leading companies and choose work hours that suit him. It is worth saying that every user has the opportunity to receive a salary daily, but if someone has difficulties with this, the user just needs to contact shiftsmart and a support employee will help fix everything.