Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thankz,

    Madhuri

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

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Regards,

    Fouad Roumieh

    Friday, January 30, 2015 12:27 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    ASP.NET issues should be addressed at the ASP.NET forum.

    http://forums.asp.net/

    • Marked as answer by Just Karl Friday, February 20, 2015 8:47 PM
    Friday, January 30, 2015 3:25 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    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