INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
Are you a
Computer / IT professional?
Join Tek-Tips now!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
"...This is easily the most helpful website I've ever used, and this is the best forum with the quickest response time bar none...."
Where in the world do Tek-Tips members come from?
Certain reports take an excessive amount of time to execute
Posted: 5 Aug 04
(NOTE: This FAQ also posted in the "BO: Crystal Reports 4 Other topics" forum, as it is not limited to a CE problem)
Can apply to Crystal Enterprise 9 and CE-RAS 9 (all editions):
While any subreport will cause a performance hit to a main report, sometimes that hit is a lot bigger than expected.
Consider a report that contains 1 to N subreports. It is possible to have two different copies of the same exact report created, where one will open in CR or run in CE/CE-RAS in a matter of seconds, while the other might take over a minute just to open up (most noticable in CR). You can see the time it takes by going to the menu
And selecting the "Performance Timing" node in the tree.
Similarly, if you're running a report through Standalone RAS or CE, you can add some timing to your .asp page (or whatever method you're using)--the line to time is going to look something like:
ReportDoc.open "rassdk://" & ReportPath & ReportName
The problem lies with how the subreports are imported in the original main report. Importing them through a UNC-mapped drive can kill your performance. The relevant information is here:
Note that if it takes your report a minute to open in Crystal Reports, it will take the same amount of time, plus your data access and execution time, for the report to run through CE or Standalone RAS. If you have a poor performing report on those systems, try opening the report in CR first and see if this is the problem--it might not be RAS or CE, but they're definitely affected by it.
You can tell if a subreport has been imported this way by right-clicking on the subreport in CR and choosing "re-import subreport". This works best if the subreport does not exist in the exact location from where it was originally imported, because CR will tell you it can't find the report at path "\\networkserver\d\reports\etc" or something like that. If it displays a UNC path like that, re-import the subreport from a local copy (e.g., c:\temp\mysubreport.rpt), save, and then re-open the report in CR. You should see substantial improvement in performance.
Back to Business Objects:Crystal Enterprise FAQ Index
Back to Business Objects:Crystal Enterprise Forum
Join Tek-Tips® Today!
Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.
Here's Why Members Love Tek-Tips Forums:
- Talk To Other Members
- Notification Of Responses To Questions
- Favorite Forums One Click Access
- Keyword Search Of All Posts, And More...
Register now while it's still free!
Already a member? Close this window and log in.
Join Us Close