I am trying to find a way on how to disable the "Include report" option from the Email subscription page. As per our requirement, users will create their own subscriptions for specific reports. But as a DBA we would like to control their ability to include the report in the email. Rather they just need to get a link of the report to their email addresses. As it showed in this screenshot
The end goal is, I want to allow my users to setup their own subscriptions which sends them a link to the report but not to include the report itself due to PII and PHI. I am using SSRS 2016 Native mode.
Any ideas or solutions are greatly appreciated.
Microsoft provided us two solutions for this. One of them was what Harry suggested in his comments- creating a trigger to update the ExtensionSettings column on Subscriptions table. Which is not supported by the Microsoft.
The only solution which is more or less official by the Microsoft is- in the Reportserver config file, we need to comment out all the rendering extensions except HTML4.0, HTML5, and RPL. After commenting out all the rendering extensions, when we setup a new subscription, everything will be greyed out for 'include report' because there are no attachment supported rendering extensions available. Since there are no include report options, the Include Link is forced by default. I tested this on our dev environment and it worked perfectly fine.
The only possible draw back with this option is that after the recipient follows the link he/she received to the Report in the web browser, they have no options available to export to pdf, etc. Which is actually a good thing in our scenario.
Image-Commenting out Rendering Extensions-Screenshot
Thanks.
