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: Today @ 4:45 AM
Points: 7, Visits: 15
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: Saturday, October 4, 2014 8:28 AM
Points: 9, Visits: 103
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: Yesterday @ 4:28 AM
Points: 83, Visits: 725
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