locked
SSRS Subscription error "An error occurred during rendering of the report" RRS feed

  • 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

    Wednesday, February 11, 2015 3:11 AM

Answers

  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 24, 2015 3:18 AM

All replies

  • Wednesday, February 11, 2015 3:16 AM
  • 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 

    Wednesday, February 11, 2015 4:42 AM
  • 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

    Friday, February 13, 2015 12:42 AM
  • 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

    Friday, February 13, 2015 8:46 AM
  • 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

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, February 24, 2015 3:18 AM