Skip to Content

Crystal report 2013 and Sections are SLOW

Dear All,
I have a problem with a Crystal report with 15 Subreport that has the Employees in section.

If I refresh the report that extract 160 Employess in section It takes 7 sec to refresh the report but when I moving from
the first section to the last one It takes very long time...

I guess this happen because Crystal refresh the report from the first Employee section till to the last one... in fact after that refresh
has finished I can moving fast to all the Employee present in the bookmark.

There is any way in order to refresh only the Employee selected in Crystal report bookmark ?

Best regards,


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Jan 15, 2016 at 05:42 PM

    Not really. In order to find the first page of the specified user, Crystal has to render all of the pages between where you are and that page - it can't just jump to the data.

    If you want to "preload" the pages (this will make the report take longer to appear when you run it), you can included either "Page N of M" or "Total Pages" on the report. This will force Crystal to render the whole thing before showing the first page.


    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Jan 15, 2016 at 06:33 PM

    Hi Michael,

    If you want to speed sub report data retrieval time then please apply one more parameter and link with sub report or restrict inactive records/ employees in subreport sql.

    This will reduce number of records counts, every time you refresh main report , main reports each record get linked with sub report data so it takes time.


    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.