locked
Rendering Size limitation on SSRS 2008R2 in Sharepoint 2010 RRS feed

  • Question

  • Hello All, 

    It has been a while we havent figure out a solution to resolve this issue. 

    The environment we have is SSRS2008 R2+ Sp2010. One of the report in this environment cannot download to the excel/PDF/Word formats as the rendering file can be as big as 64MB. Now it only works for CSV file as the size of CSV is 40 MB.

    Does anyone know what parameter value in Sharepoint site can be revised to enlarge the download size limitation?

     


    Derek

    Saturday, December 20, 2014 6:03 AM

All replies

  • Hi Derek Dai,

    According to your description, there is SSRS report in sharepoint mode, you could not download it to Excel, Pdf or Word format, since the size of the report is to large, you can only download it to CSV format.

    The report server does not limit the size of a report definition. However, ASP.NET imposes a maximum size for items that are posted to the server. If we upload or publish a report definition that exceeds this limit to a report server, you receive an HTTP exception.

      

    In this case, we can set the executionTimeout to 3600 (seconds) and set maxRequestLength to 2097151 in the httpRuntime tag of the SharePoint web.config file like below:

     <system.web>
          <httpRuntime maxRequestLength="2097151" executionTimeout="3600"/>
        </system.web>


    In addition, it is recommended to reduce the size of the record set being returned report if performance is not at an acceptable level as the design of the report does not allow for any modifications to be made to tune performance further in the report design itself.

    For more information about Report Size and Limits, please refer to the following document:
    http://msdn.microsoft.com/en-us/library/aa237805(SQL.80).aspx

    If you have any more questions, please feel free to ask.

    Thanks,
    Wendy Fu


    If you have any feedback on our support, please click here.

    • Proposed as answer by Visakh16MVP Tuesday, December 23, 2014 6:42 AM
    • Marked as answer by Wendy Fu Monday, December 29, 2014 3:09 AM
    • Unmarked as answer by Derek Dai Monday, December 29, 2014 3:17 AM
    Tuesday, December 23, 2014 6:27 AM
  • This piece of XML config file is to control the uploading size or say it is for RDL file publishing size but it is not for rendering size.

    Derek

    Tuesday, December 23, 2014 4:16 PM
  • The solution you recommended is for enlarging the upload size or say RDL publishing size but not the rendering size. So , I tried but not working.

    Derek

    Monday, December 29, 2014 3:17 AM