Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Limit the export formats Expand / Collapse
Author
Message
Posted Friday, May 24, 2013 3:26 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 25, 2014 6:31 AM
Points: 1, Visits: 23
When I run a report in Reporting Services, it allows me to Export the report in various formats.

I want to limit this to just PDF and CSV.

I have researched this and suggestions are that I edit the RSReportServer.Config file.

In the file I have foud this

<ExcludedRenderFormats>
<RenderingExtension>HTMLOWC</RenderingExtension>
<RenderingExtension>NULL</RenderingExtension>
<RenderingExtension>RGDI</RenderingExtension>
</ExcludedRenderFormats>

So as a test I added

<RenderingExtension>TIFF</RenderingExtension>

I then restarted the Reporting Services service.

This has had no affect.

Am I on the right track?



Post #1456344
Posted Monday, June 3, 2013 3:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, December 11, 2014 2:39 PM
Points: 9, Visits: 105
happyslug,
It's got to be in that section. I haven't excluded formats, but I did have to make changes for the csv export to not be Unicode, and it was in that general section, and the change worked.
Brenda
Post #1459493
Posted Thursday, June 6, 2013 1:39 AM


SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 15, 2014 7:14 AM
Points: 87, Visits: 768
Hi Happyslug,

What you need to do is set the visible property to false on the rendering extensions.

Find your extensions in the RSReportServer.Config file e.g.

&lt;Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"&gt;

and add Visible="false" like so:

&lt;Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/&gt;

Repeat for the ones you wish to hide.
Post #1460556
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse