Multiple export format options are provided by default in the report export function of reporting services, but in many cases, all format options are not required. Therefore, you need to restrict these options. The following uses SQL Server 2008 R2 as an example to describe how to restrict these options.
1. Open the report service configuration file: "C: \ Program Files \ Microsoft SQL Server \ msrs10_50.qualified \ Reporting Services \ Report Server \ rsreportserver. config ".
2. Find the label "<render/>" in the configuration file and find the following configuration lines:
<Render> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering"/></Render>
Name is the name of the format option displayed in the export report menu.
3. Add the property item "visible =" false "" to the configuration tag of the format option "":
<Render> <Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" Visible="false" /></Render>
4. Save the modified configuration file and refresh the report display page to see the effect after the restriction.
See:
Http://www.sqlserver-training.com/how-to-disablerestrict-ssrs-export-format-
[How] How to restrict the format options in the report export function of Reporting Services