Click here to Skip to main content
65,938 articles
CodeProject is changing. Read more.
Articles / SSRS

Editing SSRS reports from notepad

4.67/5 (3 votes)
23 Apr 2010CPOL 1  
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. :)

License

This article, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)