none
Downloading Report Issue

    Question

  • Hi,

    When I run a report from Visual Studio it runs almost instantly.

    However, when I download through my code it takes at least 5mins.

    Why is this? Below is the point where it takes the 5mins...

    Byte[] results;
    private ReportExecution2005.ReportExecutionService rsExec;
    
    rsExec = new ReportExecution2005.ReportExecutionService();
    results = rsExec.Render(format, deviceInfo,
                          out extension, out encoding,
                          out mimeType, out warnings, out streamIDs);
    Thanks!
    Wednesday, November 13, 2013 1:51 PM

All replies

  • Hi Obriendev,

    In Reporting Services, we can export reports to multiple format by using the export button, we can download the RDL file from the Report Manager. And we can download all RDL files from Report Server in one go using the script. In your scenario it takes five minutes to download the report, the issue may be related to your code. Here is a sample code to download all the RDL file.
    http://www.sqlservercentral.com/blogs/juggling_with_sql/2013/08/07/ssrs-download-all-rdl-files-from-report-server-in-one-go/

    Hope this helps.

    Regards,
    Charlie Liao

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


    Charlie Liao
    TechNet Community Support

    Thursday, November 14, 2013 1:57 AM
  • Hi,

    I have used the code from below article. Any idea where this code can be changed to spped up process?

    http://www.codeproject.com/Articles/15555/Generating-PDF-reports-programmatically-using-SQL

    Thanks.

    Thursday, November 14, 2013 9:17 AM
  • There is over 13000 rows of data to load into report. So this obviously an issue?

    I do not understand why it is timing out though.

    Tuesday, November 19, 2013 4:20 PM
  • Hi Obrienkev,

    Sorry for the delay.

    According to your description, you export the report to PDF using C# code, PDF and Excel have the slowest performance, but for different reasons. PDF is CPU-intensive, while Excel is RAM-intensive. And there are 13000 records on your dataset, this can be one of the issues. So in your scenario, you can try to export to report to other format and check whether this issue persists.

    Regards, 


    Charlie Liao
    TechNet Community Support

    Thursday, November 21, 2013 4:45 AM
  • Hi,

    Same issue exporting to csv. It looks like its the streaming render section where it times out...

    results = rsExec.Render(format, deviceInfo,
                          out extension, out encoding,
                          out mimeType, out warnings, out streamIDs);

    Thursday, December 05, 2013 5:27 PM