Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Report performance Issue Post Reply Post New Topic
Author Message
crystal2012
Newbie
Newbie


Joined: 17 Apr 2012
Online Status: Offline
Posts: 36
Quote crystal2012 Replybullet Topic: Report performance Issue
    Posted: 14 Aug 2012 at 8:28am

My report has very poor performance as to run time because of subreport.

Any suggestion on improving performance?
 
Thanks!
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 14 Aug 2012 at 8:58am
Hi
 
There is few factors which will case performance like ;
 
 
Special Fields : PageNofM
 
If you place your sub report in a repeted sections like 'Groups / Detaile.  Please remove your sub report from group or detail and place it either Report header / Report footer -- this will be executed only once.
 
or
 
If you are linking more tables, shift to Add Command which will be executed fast and also if you have any report level parameters try to create at Command level this will filter the data and get the required data into your report.
 
or
 
If you are using any Dynamic Parameters, try to create a Business View and create List of Values at Business View end and schedule it, this will reduce the time of getting list of values when you refresh your report.
 
or
 
Try to avoid running totals if any
 
 
Thanks,
Sastry
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.