65.9K
CodeProject is changing. Read more.
Home

Editing SSRS reports from notepad

starIconstarIconstarIconstarIcon
emptyStarIcon
starIcon

4.67/5 (3 votes)

Apr 23, 2010

CPOL
viewsIcon

25130

As the SQL Server 2008 SSRS report files are stored in XML format, we can open the report file (.rdl) from Notepad and edit the content. For example - this is useful in replacing all the calls to one dataset name, when a new report is copied from existing one and the dataset name is different...

As the SQL Server 2008 SSRS report files are stored in XML format, we can open the report file (.rdl) from Notepad and edit the content. For example - this is useful in replacing all the calls to one dataset name, when a new report is copied from existing one and the dataset name is different for the new report. If there are N number of text fields and need to change color of the text fields from #efefef (Gray) to #ccccff(light blue), we can direct edit in notepad and replace all. When saved the Visual Studio will just say the report is edited outside and will load with new changes. :)