a blog for those who code

Wednesday 2 January 2019

How to Solve delivery error has occurred in SSRS 2017 Subsciption

In this post we will be discussing about solving A delivery error has occurred in SSRS 2017 when trying to create a Subscription from ASP.NET UI and keeping Excel as delivery option. As you might know that we can create Subscription from ASP.NET code using ReportingServices Class, but when you try to keep delivery option as Excel from the ASP.NET code it throws the below error :

ErrorCode : rsDeliveryError
HttpStatus : 400
Message : A delivery error has occurred.
ProductName : Microsoft SQL Server Reporting Services
Event Id : rsInvalidExtensionParameter
Error Message : One of the extension parameters is not valid for the following reason: The value 'Excel' is not valid for setting 'Render Format'.

Now that means it is not able to recognize the word EXCEL when we set it as a Delivery Option. By looking at the Reporting Services config file we can see the below lines which means EXCEL is already setup but the problem was it's type. Not only Excel but Work also has the same problem thus giving the same error. So We have to replace the below lines

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

<Extension Name="EXCELOPENXML" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>

<Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordDocumentRenderer,Microsoft.ReportingServices.WordRendering" Visible="false"/>

<Extension Name="WORDOPENXML" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordOpenXmlRenderer.WordOpenXmlDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>

With the below lines.

<Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelOpenXmlRenderer.ExcelOpenXmlRenderer,Microsoft.ReportingServices.ExcelRendering"/>

<Extension Name="WORD" Type="Microsoft.ReportingServices.Rendering.WordRenderer.WordOpenXmlRenderer.WordOpenXmlDocumentRenderer,Microsoft.ReportingServices.WordRendering"/>

What are we doing here is telling the Reporting Services to use EXCEL and WORD in an updated format (.xlsx and .docx) thus eventually we do not need EXCELOPENXML and WORDOPENXML anymore.

Please Like and Share the CodingDefined.com Blog, if you find it interesting and helpful.

No comments:

Post a Comment