Performance isssue while pulling rdlc report in asp.net web forrm RRS feed

  • Question

  • Hi,

    I have an issue with my rdlc report. I am calling rdlc report in asp.net web form where it takes 3 mins to pull a report. I am using Stored procedure in rdlc report. This Stored procedure is taking 50 sec to execute in ssms.  are there any key area's i need to concentrate for resolving performance issue.



    • Moved by Kristin Xie Monday, February 9, 2015 2:39 AM
    Friday, January 30, 2015 4:20 AM


All replies

  • Hi,

    I'm seeing that the SP exec time (50 sec) is too big also, so that should be the first issue to investigate. Also please provide some info about the report & data size you loading (db records, pages, grouping levels available...). Does your report contain images/graphics into it?. In the mean time try below tips:

    1- Load fewer data and see if performance get enhanced.

    2- Try to block/suppress some sections of the report mainly if you have grouping or complex calcutions and see if performance enhanced. This will help to figure out the problem.

    3- Check this article it contains some tips also.


    Fouad Roumieh

    Friday, January 30, 2015 12:27 PM
  • ASP.NET issues should be addressed at the ASP.NET forum.


    • Marked as answer by Just Karl Friday, February 20, 2015 8:47 PM
    Friday, January 30, 2015 3:25 PM
  • please move your problem to asp.net forum

    Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]

    • Proposed as answer by Ammar.Zaied Friday, February 6, 2015 3:25 PM
    Friday, February 6, 2015 3:25 PM