SSRS - Disabling export options (eg. PDF) for individual reports

rdlc report hide export option
disable print button in ssrs report viewer
ssrs export to pdf issues
ssrs report render format
ssrs pdf
ssrs client side reporting
ssrs 2016 print dialog without pdf viewer
ssrs print control

We have many reports which we use on the website. While exporting some reports as PDF, the file size gets huge and the server crashes due to load. So it would be great if I can disable export to PDF option only for certain problematic reports.

So is there a way to disable certain export options (example: export to PDF) in report viewer 9.0 (SSRS), for individual reports?

Thank you.

Just in case nobody else said it out loud before here or in linked articles:

The neatiest global solution is to find the rendering engines in the RS config file (mine sits in: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config), go to xml key: Extensions > Render and insert following property at the end of each entry you want to hide:

Visible="false"

Example:

<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>

Alternatively put <!-- and --> (HTML comment markers) at the beginning and end of the entry.

For individual reports those functions will do the trick.

Disable Export Options Per Report in SSRS 2012/ 2014, How do I remove PDF option from export options in SSRS report? If we want to disable export options for all reports in SQL Server Reporting Services (SSRS) 2012/ 2014, then we would set the parameters in the RSReportServer.config file on the Reporting Server. However, most of the time, you are going to want to be able to export at least a few reports, so how do we disable exports for only a few reports?

You can hide PDF button globally in a specific config file here:

"InstallPath\Reporting Services\ReportServer\rsreportserver.config"

For more information, there is already a topic about this on StackOverflow.

Please check for more answers here: ReportViewer - Hide PDF Export

Enable and Disable Client-Side Printing for Reporting Services , ) 2012/ 2014, then we would set the parameters in the RSReportServer. config file on the Reporting Server. I have seen options for disabling certain options server wide but nothing for a single report using ReportManager . Preferably the export button would simply not be there. sql-server reporting-services ssrs-2008 ssrs-2008-r2

You can use Pre_render event in Report Viewer.

  protected void ReportViewer1_PreRender(object sender, EventArgs e)
        {
            DisableUnwantedExportFormat((ReportViewer)sender, "Excel");
            DisableUnwantedExportFormat((ReportViewer)sender, "Word");
        } 

Take a look at this post

Example Remove save As in SSRS

How do I enable client side printing from SQL Reporting Services server? In some of my SSRS reports, I want to disable the CSV option in the report Export feature. I know how to disable exporting to CSV for the entire SSRS server, but I don't know how to do this for an individual report.

My solution for this

$(document).ready(function() {
        var sel = $("select#ReportViewer2_ctl01_ctl05_ctl00");
        sel.find("option[value='XML']").remove();
        sel.find("option[value='CSV']").remove();
        sel.find("option[value='IMAGE']").remove();
        sel.find("option[value='MHTML']").remove();
        sel.find("option[value='PDF']").remove();
        sel.find("option[value='EXCEL']").remove();
});

However I am wondering how to disable for instance PDF and only allow user to To disable export option for specified report, we can add a piece of Example to disable save as certain file type in SSRS Report Viewer. Export Reports (Report Builder and SSRS) 05/30/2017; 11 minutes to read +5; In this article. You can export a Reporting Services report to another file format, such as PowerPoint, Image, PDF, Microsoft Word, or Microsoft Excel or export the report by generating an Atom service document, listing the Atom-compliant data feeds available from the report.

This solves the problem (partially for us):

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/0c680c69-9f7d-42aa-a6b4-b1178eab8adf

If we want to disable export options for all reports in SQL Server just save the script in the Report.apsx page of the SSRS server. Example: /My New Report/​Report Test 1 => /MyNewReport/ PDF - Removes PDF. Is there a way to disable "Export Data" just to a particular report. I saw many posts in which we can disable int he admin portal. But would that apply to all the reports in the workspace? 1. I would just need this feature for a particular report 2. I dont see any options in Admin portal excep

Disable the PDF export option - add the visible attribute with value false . Enable the PDF export option - remove the visible attribute. Hi, I'd like to know if it is possible to disable exporting data from a Report I've published to our report server? I only want to disable this at a report level, so some of the reports on the server must allow exporting of data while some must not allow exporting of data. what settings do I cha

SSRS - Disable export options (e.g. PDF) for individual reports We have many posts that we use on the website. When exporting some reports in PDF f Rendering Behaviors (Report Builder and SSRS) 03/07/2017; 7 minutes to read +1; In this article. Depending on the renderer you select, certain rules are applied to the report body and its contents when rendering a report. How report items fit together on a page is determined by the combination of these factors: Rendering rules.

Is it possible to disable the pdf export only for specific reports ?? /15831328/​ssrs-disabling-export-options-eg-pdf-for-individual-reports. The report does not contain data, but users with appropriate permissions can access the property pages, security settings, report history, and subscription information associated with the report. SharePoint mode: To disable a shared data source in a SharePoint mode report server, browse to the document library that contains the data source.

Comments
  • Nice concise answer!
  • Just to share that is possible to do it for Power BI Report Server (On-Premise). The location of the file should or could be at: C:\Program Files\Microsoft Power BI Report Server\PBIRS\ReportServer. It is important to restart the Report Server instance at the Report Server Configuration Manager to make it effective.
  • Thank you. But wouldn`t disabling globally disable "export to PDF" for all reports? What we want to achieve is to be able to disable the export to PDF only for individual reports.
  • The link in the end of my answer contains more solutions for this particular problem without globally disabling PDF exports.
  • Hi shamcs, Where would I place the above code. I don't think it goes into custom code section of the report
  • @MarkOKeeffe you can follow the link that i give there, on report viewer controller, add action to event OnPreRender.
  • This likely worked at the time the question was answered, but doesn't in the newer version of SSRS. See my answer for more information.