Print Page | Close Window

Report taking 12 min to render on linked tables

Printed From: Crystal Reports Book
Category: Crystal Reports for Visual Studio 2005 and Newer
Forum Name: Report Design
Forum Discription: The best way to design a report and problems you have encountered
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=13123
Printed Date: 20 Apr 2025 at 3:05pm


Topic: Report taking 12 min to render on linked tables
Posted By: rgn2121
Subject: Report taking 12 min to render on linked tables
Date 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?


Replies:
Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics

Posted By: rgn2121
Date Posted: 14 Jun 2011 at 1:40am
The report is fed by an in memory dataset, not a db server.

Posted By: hilfy
Date 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
http://www.protiviti.com/US-en/data-management-advanced-analytics - www.protiviti.com/US-en/data-management-advanced-analytics


Print Page | Close Window