SSRS - Make common change in multiple reports in one click

Consider a scenario, say if there are more than 100 reports developed already. Each & every report has company logo on header as embedded image. Suddenly, if the company has decided to make minor change in the logo and all the reports needs to be modified with new logo image.

To make common change in multiple reports in one click, we need to create 
  1. Stored procedure 
  2. SSIS package

 Worked Example:

 I have created six sample reports with "SQL Server 2014" image in the header as shown below:






 Say, if the requirement is to change the header image as "SQL Server 2016" in all the reports.
 I have changed the header image as "SQL Server 2016" manually for Report1.rdl alone as shown below:




 Now after executing the SSIS package:
   i) Except Report1.rdl other five RDL's are copied to backup folder.
  ii) Remaining reports are modified with new header image and imported into report solution folder.


  • By making modifications in Stored procedure (by altering the XML tag of RDL that needs change), this tool can be used to make any common change in multiple reports in one click 
I have posted the Stored procedure and SSIS package screenshots in my Technet Wiki article.

No comments: