INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • 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.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

Subreports

Adding subreports cause my report to open/run slowly. by caimoss
Posted: 5 Aug 04 (Edited 5 Aug 04)

(NOTE: This FAQ also posted in the "BO: Crystal Enterprise" forum, as it may not be diagnosed as a Crystal Reports problem, but as a CE problem)

Applies to Crystal Reports 9 (Advanced, Developer, Professional, Standard):

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

Report-->Performance Information

And selecting the "Performance Timing" node in the tree.

The problem lies with how the subreports are imported. Importing them through a UNC-mapped drive can kill your performance. The relevant information is here:

http://support.businessobjects.com/library/kbase/articles/c2014546.asp

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.

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 Reports 4 Other topics FAQ Index
Back to Business Objects: Crystal Reports 4 Other topics Forum

My Archive

Resources

Close Box

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:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close