Click here to Skip to main content
15,881,882 members
Articles / SSRS
Tip/Trick

Editing SSRS reports from notepad

Rate me:
Please Sign up or sign in to vote.
4.67/5 (3 votes)
23 Apr 2010CPOL 24.3K   2   3
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)


Written By
Technical Lead
India India
Hi, I am Narsimlu Keshagouni working as Technical Lead in Hyderabad, India.

Comments and Discussions

 
QuestionProblem with SSRS Authentica​tion - don't want to use Custom Authentica​tion - Please guide Pin
Member 1069685125-Mar-14 4:23
Member 1069685125-Mar-14 4:23 
QuestionVery good Pin
Paulo Augusto Kunzel4-Oct-13 1:53
professionalPaulo Augusto Kunzel4-Oct-13 1:53 
GeneralBasic Plain Report Tags are : <?xml version="1.0" encoding=... Pin
Member 34359822-Sep-10 4:56
Member 34359822-Sep-10 4:56 
Basic Plain Report Tags are :


<report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner">
<datasources>
<datasource name="datasourcename">
<rd:datasourceid>9ed0f7db-8631-48da-8fe0-988ee4c3ed1a
<datasourcereference>dsname


<datasets>
<dataset name="name">
<fields>
<field name="field1">
<datafield>field1
<rd:typename>System.DateTime


<query>
<datasourcename>dsname
<commandtext>select * table
<rd:usegenericdesigner>true





<reportitems>

<top>0.625in

or or

<tablerows>
<tablerow>
<tablecells>
<tablecell>
<reportitems>

<textbox name="textbox4">




<height>0.25in



or or




<height>2in

<language>en-US
<topmargin>1in

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.