Post reply

SSRS 08 Word Rendering

  • May 18, 2011 at 11:15 am

    #238387

    I have a need to REMOVE MS-Word as an export option in Reporting Services 2008. We want users to export to PDF and not the other formats. Of course MS-Word is the one they always want to use.

    Does anyone know of a way to do this in SSRS 2008? I realize that most requests since SSRS 2005 have been to add MS-Word to the export function so this may seem kind of silly, but our reports are too complex for MS-Word to handle and they won't render anyway. Having it show up in the list of options is a problem.

  • May 19, 2011 at 3:12 am

    #1326930

    Try this :

    http://mysqlserverblog.com/2008/01/03/changing-export-options-for-reporting-services.aspx

    Change the directories to suit a 2008/R2 setup

    gsc_dba

  • May 19, 2011 at 3:18 am

    #1326931

    gsc_dba (5/19/2011)

    Try this :

    http://mysqlserverblog.com/2008/01/03/changing-export-options-for-reporting-services.aspx

    Change the directories to suit a 2008/R2 setup

    Also works in a Sharepoint integrated setup.

    🙂

    []Use <!-- to comment out the parts you dont want (as opposed to deleting the lines) -->

    Or...suffix the string with Visible="false"

    <Render>

    <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"/>

    <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.DataRenderer.CsvReport,Microsoft.ReportingServices.DataRendering"/>

    <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PDFRenderer,Microsoft.ReportingServices.ImageRendering"/>

    <Extension Name="RGDI" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.RGDIRenderer,Microsoft.ReportingServices.ImageRendering" Visible="false"/>

    <Extension Name="HTML4.0" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.Html40RenderingExtension,Microsoft.ReportingServices.HtmlRendering" Visible="false"/>

    <!--<Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/> -->

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

    <Extension Name="RPL" Type="Microsoft.ReportingServices.Rendering.RPLRendering.RPLRenderer,Microsoft.ReportingServices.RPLRendering" Visible="false" LogAllExecutionRequests="false"/>

    <!--<Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering"/> -->

    <!--<Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering"/> -->

    </Render>

    gsc_dba

  • May 19, 2011 at 2:21 pm

    #1327343

    That was pretty darn simple 🙂

    Thank you!

Viewing 4 posts - 1 through 4 (of 4 total)

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