Change the default Reporting Services delivery extension
You can modify Reporting Services configuration settings to change the default delivery extension that appears in the Delivered by list of a subscription definition page. For example you can modify the configuration so that when users create a new subscription, file share delivery is selected by default instead of e-mail delivery. You can also change the order the delivery extensions are listed in the user interface.
Applies to: Reporting Services Native mode | Reporting Services SharePoint mode
Reporting Services includes E-mail and Windows File Share delivery are extensions. Your report server might have other delivery extensions if you deployed custom or third-party extensions to support custom delivery. The availability of a delivery extension depends on whether you deploy it on a report server.
Default native mode report server configuration
The order of a delivery extension appears in Report Manager in the Delivered by list is based on the order of the delivery extension entries in the RSReportServer.config file. For example, the following image shows e-mail first in the list and is the default.
The following is the default section of RSReportServer.config that controls the default delivery extension and the order they're displayed in Report Manager. Email appears first in the file and is the default.
<DeliveryUI>
<Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider">
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
<Configuration>
<RSEmailDPConfiguration>
<DefaultRenderingExtension>MHTML</DefaultRenderingExtension>
</RSEmailDPConfiguration>
</Configuration>
</Extension>
<Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"/>
</DeliveryUI>
Configure file share delivery as the default delivery extension in Report Manager
The steps in this procedure modify the configuration so that file share delivery is listed as the first option in the UI and it's the default selection.
Open the RSReportServer.config file in a text editor. For more information on the configuration file, see RsReportServer.config configuration file. After the configuration changes, the UI will look like the following image:
Modify the DeliveryUI section to look like the following sample and note the key changes of:
The FileShare extension is before the email extension. This setting changes the order the extensions are listed in Report Manager.
The File share extension contains DefaultExtension tag
<DefaultDeliveryExtension>True</DefaultDeliveryExtension>
and the extension end tag was added</Extension>
.The email extension is no longer configured as the default.
<DefaultDeliveryExtension>False</DefaultDeliveryExtension>
<DeliveryUI> <Extension Name="Report Server FileShare" Type="Microsoft.ReportingServices.FileShareDeliveryProvider.FileShareUIControl,ReportingServicesFileShareDeliveryProvider"> <DefaultDeliveryExtension>True</DefaultDeliveryExtension> </Extension> <Extension Name="Report Server Email" Type="Microsoft.ReportingServices.EmailDeliveryProvider.EmailDeliveryProviderControl,ReportingServicesEmailDeliveryProvider"> <DefaultDeliveryExtension>False</DefaultDeliveryExtension> <Configuration> <RSEmailDPConfiguration> <DefaultRenderingExtension>MHTML</DefaultRenderingExtension> </RSEmailDPConfiguration> </Configuration> </Extension> </DeliveryUI>
Save the configuration file.
Within a few minutes the report server reloads the configuration file, and the new settings take effect. You can restart the report server service to force the loading of the configuration file.
The following event is written to the Windows event log when the configuration is read.
Event ID: 109
Source: Report Server Windows Service (instance name)
The RSReportServer.config file is modified
SharePoint mode report servers
Reporting Services SharePoint mode stores extensions information in the SharePoint service application databases and not in the RsrReportServer.config file. In SharePoint mode, delivery extension configuration is modified by using PowerShell.
Configure the default delivery extension
Open the SharePoint Management Shell.
You can skip this step if you already know the name of your Reporting Services service application. Use the following PowerShell to list the Reporting Services service applications in your SharePoint farm.
get-sprsserviceapplication | format-list *
Run the following PowerShell to verify the current default delivery extension for the Reporting Services service application "ssrsapp".
$app=get-sprsserviceapplication | where {$_.name -like "ssrsapp*"};Get-SPRSExtension -identity $app | where{$_.ServerDirectivesXML -like "<DefaultDelivery*"} | format-list *
Related content
RsReportServer.config configuration file
RsReportServer.config configuration file
File share delivery in Reporting Services
E-Mail delivery in Reporting Services
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for