How to change Rendering Extensions in SQL Server Reporting Services
The SQL
Server Reporting Services rendering extensions are managed through the
configuration file "RSReportServer.config". You can find this
configuration file in the "ReportServer" folder. The complete path of
the folder is C:\Program Files (x86)\Microsoft SQL
Server\MSRS11.MSSQLSERVER\Reporting Services\ReportServer. Your
configuration folder location may be slightly different.
Open the
"RSReportServer.config" file in Notepad and search for the
node name, you can find all available rendering extensions there. You can refer
to the code for the first two rendering extensions "XML" and
"NULL".
<Reader>
<Extension
Name="XML"
Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,
Microsoft.ReportingServices.DataRendering"/>
<Extension
Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NULLRenderer.NULLReport,
Microsoft.ReportingServices.NULLRendering"
Visible="false"/>
(Note- Be careful when changing the report server configuration
file; it is recommended to create a back-up of the RSReportServer.config file
before modification.)
If we add
an attribute Visible="false" for the "XML" rendering
extension, then it should not show in the rendering extension drop down list.
Let's add an attribute Visible="false" for the "XML"
rendering extension, after the changes the file should look like below.
<Reader>
<Extension
Name="XML"
Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,
Microsoft.ReportingServices.DataRendering"
Visible="false"/>
<Extension
Name="NULL"
Type="Microsoft.ReportingServices.Rendering.NULLRenderer.NULLReport,
Microsoft.ReportingServices.NULLRendering"
Visible="false"/>
Thanks for your feedback
ReplyDeleteThanks for your feedback
ReplyDelete