Limit the export formats

  • 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?

  • 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

  • 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.

    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering">

    and add Visible="false" like so:

    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

    Repeat for the ones you wish to hide.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply