Customize Report View Web Part in RS-Sharepoint Integrated Mode

Microsoft documentation at best alludes to the ability to modify 2 aspects of this web part, and similar to modifications for Report Manager.

1) Remove Export file types – Users don’t need more than PDF, Excel, and Image export types. Makes for a cleaner interface.

2) Remove Print Control – ActiveX that is only IE compatible and even MS’s own docs say the best way to printer is to export to PDF and then print!.

In the web part these are under the Actions dropdown.

Modify the List of Export File Types

Directly modify the rsreportserver.config file located on the RS server in the \MSRS10_Instancename\Reporting Services\ReportServer folder. The drive\folder is configured during initial installation of Report Services so it will vary.

Find the section for <Render> and locate the <Extension Name=….> you want to modify and add Visible=”false” within the /> – Example:

<Extension Name=”IMAGE” Type=”Microsoft.ReportingServices.Rendering.ImageRenderer.ImageRenderer,Microsoft.ReportingServices.ImageRendering”/>
<Extension Name=”WORD” Type=”Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering”
Visible=”false”/>

The “Word” export type will be removed from the Export list. Do this for any of the export types you want removed or added as some like the RPL or HTML4.0 are removed by default..maybe you want to add them back.

No need to restart the server as the changes will be immediately picked up when you refresh the Sharepoint page..

Removing the Print Control

MSDN article – suggests a programmatic (sketchy) way of enable/disable the ActiveX print control but I recall I’d previously made this setting change and have re-discovered it. This article was helpful in noting the setting name “EnableClientPrinting”.

Searching the \Reportserver application folder for the “EnableClientPrinting” setting it was revealed within the file Catalog.sql (script used in installation) as a value in the database supporting RS. Ahhh – *lightbulb goes on*.

Fire-up SSMS and select connect to Report Server – remember in RS-SQL2008 that IIS is out so you access some settings via SSMS – and to connect you enter the full URL to the RS reportserver,

https://xxxxx/reportserver

Once connected in SSMS you’ll see the server name and under that Jobs/Security/Shared Schedules. Mouse over the server name and rt-click for the popup menu and select Properties. Bingo! – you’ll see the “Enable Client Printing” checkbox towards the bottom of the General Settings.

Category: Sharepoint Customize
Published: 2/16/2010 3:02 PM
Updated: 12/05/2010