Getting Started with Adobe After Effects - Part 6: Motion Blur


Upload Image Close it
Select File

My technology blog on SQL Server, TSQL, XML, FILESTREAM and other areas of SQL Server.
Browse by Tags · View All
XML 112
TSQL 69
XQuery 69
XQuery Functions 67
XQuery Training 65
XQuery in TSQL 64
XQuery Tutorial 63
SQL Server XQuery 63
XQuery-Labs 57
BRH 38

Archive · View All
September 2008 32
August 2008 30
July 2008 21
August 2009 19
June 2009 19
May 2010 18
January 2009 15
January 2010 14
October 2008 14
June 2008 13

SSRS Report Viewer- How to show/hide rendering extensions (export formats)

May 13 2013 12:00AM by Jacob Sebastian   

This post is inspired by a question in MSDN forum about disabling certain rendering formats when setting up SSRS subscriptions. This can be achieved by changing the SSRS configuration file as explained below.

I never had a real-world scenario where I needed to disable/hide a rendering extension. However, the above question inspired me to explore the SSRS configuration settings and I could find that the following steps can disable/hide rendering extensions.

Step 1: Looking at the available rendering/export formats

I went to my SSRS 2008 R2 instance and ran a sample report to view the available export format and found the following.

ssrs1

From the available export options, I decided to remove “Word” format for the purpose of this experiment.

Step 2: Changing the configuration file

The rendering extensions are managed/configured through the configuration file named “RSReportServer.config” located in the “ReportServer” folder. On my laptop this file is located at C:\Program Files\Microsoft SQL Server\MSRS10_50.MSSQLSERVER\Reporting Services\ReportServer

ssrs2

Locate the node named render. On my configuration file, it looked like the following.

<render>
	<extension type="Microsoft....dering" name="XML" />
	<extension type="Microsoft...ring" name="NULL" visible="false" />
	<extension type="Microsoft....ng" name="CSV" />
	<extension type="Microsoft...endering" name="ATOM" visible="false" />
	<extension type="Microsoft....dering" name="PDF" />
	<extension type="Microsoft...endering" name="RGDI" visible="false" />
	<extension type="Micros...ervices.HtmlRendering" name="HTML4.0" visible="false" />
	<extension type="Microsof...ices.HtmlRendering" name="MHTML" />
	<extension type="Microsof...lRendering" name="EXCEL" />
	<extension type="Microsoft....ing" name="RPL" visible="false" />
	<extension type="Microsof...eRendering" name="IMAGE" />
	<extension type="Microsoft....WordRendering" name="WORD" />
</render>

I added an attribute Visible=”false” to the entry representing “Microsoft word” (Last element in the above example). After the above change is made, I went back to my sample report and found that the entry “Word” has been removed from the export format list in report viewer page/control.

ssrs3

I then went to verify that this option has been removed from the report subscription setup pages. To my surprise, I could still see “Word” appear as an option there.

ssrs4

After reviewing all the configuration settings several times, I realized that a restart of the reporting service is required to have the changes take effect in the subscription setup page. I restarted reporting service and after reboot, I could see that the render format “Word” has been removed.

ssrs5

Note

Be careful when playing with the report server configuration file. Always test your changes in the QA/Dev environment before trying on the production environment.

Tags: 


Jacob Sebastian
1 · 100% · 32235
2
 
0
Lifesaver
 
0
Refreshed
 
0
Learned
 
0
Incorrect



Submit

1  Comments  

  • This comment is waiting for moderation.

    commented on Feb 6 2015 9:51AM
    tsethuram
    3158 · 0% · 2

Your Comment


Sign Up or Login to post a comment.

"SSRS Report Viewer- How to show/hide rendering extensions (export formats)" rated 5 out of 5 by 2 readers
SSRS Report Viewer- How to show/hide rendering extensions (export formats) , 5.0 out of 5 based on 2 ratings
    Copyright © Rivera Informatic Private Ltd Contact us      Privacy Policy      Terms of use      Report Abuse      Advertising      [ZULU1097]