SSRS Subscription error "An error occurred during rendering of the report"

Question

User-2112117666 posted

I have created a subscription that will place a report on a file share. When the subscription runs to build an excel file and put it on the shared drive, it gives the following error: An error occurred during rendering of the report.

Problem is that some time subscription run successfully and sum time it give error: An error occurred during rendering of the report.

Help me

Answer 1

User1577371250 posted

Hi Asif,

Check this link

http://www.douglane.net/reporting-services-2012-bug-causes-export-to-excel-failure/

Answer 2

User-2112117666 posted

it is not helping me.

When i subscribe report with xls format it complete successfully but when i subscribe report with xlsx then above error occur. i am not understanding problem help me..

i am using sql server 2008 R2

i am using sqlserver 2008 r2 

Answer 3

User-734925760 posted

Hi,

According to your description, I think you need to make sure your report id=s correct, also you need to check other setup of your ssrs server.

There is a similar thread, please refer to the link below:

https://social.msdn.microsoft.com/Forums/en-US/5b8853de-33bd-4773-bea2-cc1877b53b43/report-subscription-error-an-error-occurred-during-rendering-of-the-report?forum=sqlreportingservices

Hope it's useful for you.

Best Regards,

Michelle Ge

Answer 4

User-2112117666 posted

When i subscribe report with xls format it complete successfully but when i subscribe report with xlsx then above error occur. i am not understanding problem help me..

i am using sql server 2008 R2

Answer 5

User1711366110 posted

When i subscribe report with xls format it complete successfully but when i subscribe report with xlsx then above error occur. i am not understanding problem help me..
i am using sql server 2008 R2

    By default, Reporting Services 2008 can only export reports to excel file as XLS format in order to maintain backward compatibility.
However, you can use the third party tools to export reports to XLSX format,
or you can also implement a custom rendering extension but it is complicated.

Click here to know more about the rendering extension overview in sqlserver 2008.

--
with regards,
Edwin