Tuesday, May 18, 2010

Removing the export menu items of the report view webpart in sharepoint Integration mode

Open the configuration file "rsreportserver.config" located at "C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer\rsreportserver.config". The config file is an Xml file which acts as the configuration for the current report services installation. From the nodes locate the sub node element named . Xml file with report data - <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/> CSV (Comma delimited) - <Extension Name="CSV" Type="Microsoft.ReportingServices.Rendering.CsvRenderer.CsvReport,Microsoft.ReportingServices.CsvRendering"/> TIFF file - <Extension Name="IMAGE" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.ImageReport,Microsoft.ReportingServices.ImageRendering"/> Acrobat (PDF) file - <Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering"/> Web archive - <Extension Name="MHTML" Type="Microsoft.ReportingServices.Rendering.HtmlRenderer.MHtmlRenderingExtension,Microsoft.ReportingServices.HtmlRendering"/> Excel - <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/> Just add the attribute Visible="false" to the Extension element which has to be hidden in the Export option, say you want to hide Xml then < Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" Visible="false"/> Go back to the webpart page and then do a page refresh and you will find that the export option is not rendered. P.S. Please make sure that you don't do the comment out or remove the Extension node unless you are sure that type of rendering will not be required, else it will shown an rendering error.

Thursday, May 6, 2010

Trick to easily go to web part maintenance page

Its by adding a query string ?contents=0, at the end of the current url and press enter or click on GO. Cheers !!