1
votes

I need to disable the option to attach a report in an SSRS subscription in SQL 2016. The only option that should be available is to send the report URL.

SSRS Subscription Setup

I am curious how to perform the recommended method from MSDN to "configure the report server to send only a report server URL" found in this article https://msdn.microsoft.com/en-us/library/ms160334.aspx.

I tried excluding a render format in my rsreportserver.config like this, but it didn't seem to do anything.

    <ExcludedRenderFormats>
      <RenderingExtension>PDF</RenderingExtension>
    </ExcludedRenderFormats>

I have a test SSRS 2016 environment installed using SSRS Native mode but if needed, I can uninstall and re-install if necessary with a non-default configuration.

1
I think that there are one or two checkboxes in the configuration for an SSRS subscription which indicate, some combination of whether or not the report output should be delivered and/or whether or not to include a link to the report in the email. - David Tansey
Yes. I'm trying to disable the check box to disallow attaching the email for all subscriptions. - godfathr
Here's a link to a kludge workaround (it's rather old too) but take a read: social.msdn.microsoft.com/Forums/en-US/… - David Tansey
From MSDN: "Delivery options that affect how the report is rendered and whether the report is attached OR linked to the e-mail can also vary from subscriber to subscriber when the values are passed in from the row set." - David Tansey
That's not what I'm trying to do at all. Did you look at the MSDN article I linked to? The suggested configuration is in there, however, HOW to make the configuration change in the rsconfiguration.config is not outlined in the article or any article that I could find. - godfathr

1 Answers

2
votes

I figured it out. In the rsreportserver.config, find this element:

<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailProvider,ReportingServicesEmailDeliveryProvider">

Inside of that element is an element to add excluded file types. Just add all the supported file types and then the attachment option is effectively disabled.

                    <ExcludedRenderFormats>
                        <RenderingExtension>HTMLOWC</RenderingExtension>
                        <RenderingExtension>NULL</RenderingExtension>
                        <RenderingExtension>RGDI</RenderingExtension>
                        <RenderingExtension>PDF</RenderingExtension>
                        <RenderingExtension>MHTML</RenderingExtension>
                        <RenderingExtension>WORD</RenderingExtension>
                        <RenderingExtension>EXCEL</RenderingExtension>
                        <RenderingExtension>PPTX</RenderingExtension>
                        <RenderingExtension>IMAGE</RenderingExtension>
                        <RenderingExtension>WORDOPENXML</RenderingExtension>
                        <RenderingExtension>EXCELOPENXML</RenderingExtension>
                        <RenderingExtension>CSV</RenderingExtension>
                        <RenderingExtension>XML</RenderingExtension>
                        <RenderingExtension>ATOM</RenderingExtension>
                        <RenderingExtension>HTML4.0</RenderingExtension>
                    </ExcludedRenderFormats>

Finally, restart the SQL Server Reporting Services services.

Desired end result:

enter image description here