Active TopicsMemberlistSearchHelpRegisterLogin

Report Design
 Crystal Reports Forum : Crystal Reports for Visual Studio 2005 and Newer : Report Design
Message Icon Topic: Report taking 12 min to render on linked tables Post Reply Post New Topic
Author Message
rgn2121
Newbie
Newbie


Joined: 05 May 2011
Online Status: Offline
Posts: 2
Quote rgn2121 Replybullet Topic: Report taking 12 min to render on linked tables
    Posted: 05 May 2011 at 1:24am
I have a report that has 2 tables (linked) coming from a dataset that is taking 12 minutes to render.  I have done everything I know to do at this point and I still can't figure it out. 
 
Originally, I had my data all in one datatable and this report produced 350 or so pages and it rendered in a matter of seconds and I could export it pretty quickly.
 
Now, the dataset has been structured better and the data is in 2 tables in a one to many type relationship.  When I try to link the tables it takes forever.  When I do an on demand subreport it takes maybe 3 seconds, but I don't know how to export to see the subreport.
 
So I went with a normal subreport.  It seemed fine and it displayed in about 3 seconds.  I went back and fornmatted the report to make it look like all the rest and bam!!  12 minutes to display....
 
Any ideas... or things to test?
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 09 May 2011 at 3:22am

What do you have in your select criteria and how are you sorting?  In the Options section of the File menu, you should try turning on the following options (I may not have the wording exactly correct...):

- Use indexes or server for speed
- Perform grouping on server
 
These options will push the selection criteria to the database server (assuming you're connecting to a client/server database like MS SQL Server, Oracle, etc. and not a file-based database such as Access).  However, if you are using any formulas in your selection criteria or your sort, Crystal may be doing those calculations in memory rather than having the database do them. 
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
IP IP Logged
rgn2121
Newbie
Newbie


Joined: 05 May 2011
Online Status: Offline
Posts: 2
Quote rgn2121 Replybullet Posted: 14 Jun 2011 at 1:40am
The report is fed by an in memory dataset, not a db server.
IP IP Logged
hilfy
Admin Group
Admin Group
Avatar

Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Quote hilfy Replybullet Posted: 15 Jun 2011 at 1:51pm
That's what your problem is.  If you have an in-memory data set that contains multiple tables with many rows, this will take time to render in Crystal because Crystal is doing all of the joins and filtering in memory.  This is why the report was so fast when it was all in one table.  You need to remember that a normalized data set is not necessarily the best structure to use for reporting, especially when you don't have a database to handle the joins and filters.
 
-Dell
Proviti, Data & Analytics Practice
www.protiviti.com/US-en/data-management-advanced-analytics
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.020 seconds.
HOME | FREE EBOOK | PROGRAMMING GUIDE | PURCHASE | REVIEWS | CONTACT ME | FAQ | LINKS | CLICK PLAYS | COACH FORUMS | TROPICAL FISH

© 2004-2025 Brian Bischof. All Rights Reserved.