Print Page | Close Window

Crystal Report Slow processing

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=15806
Printed Date: 06 Apr 2025 at 3:21pm


Topic: Crystal Report Slow processing
Posted By: Asif Sharif
Subject: Crystal Report Slow processing
Date Posted: 06 Mar 2012 at 3:55am
I am using crystal reports for visual studio 2005 for generating a report
The problem is that the report is taking so much time between the navigation of pages, and if we click the print button, system freezes,(may be because crystal report completely process report before send it to printer) so we are unable to print, I also try direct printing the report(without previewing it), report contains 2 sub reports, I used sub reports because I have to display the data in parallel like
Record 1
Child A          Child B
Child C          Child D
If I don’t use sub reports there will be white space between child A and C or child B or D because their records are not fixed, I check the report with sub reports suppress, and report works fine, I have to use sub reports and I have almost 30000 records for main report and 30000 for 1st sub report and almost 74000 for 2nd sub report, I check for 1 hour but its processing is not ended.
I m using datasets as data source for reports, I also try direct stored procedure but it not solved my issue
So if I remove sub reports my slow processing issue is fixed but I can’t display records in parallel
So there is any way to fix this issue, as for workaround I can filter records, but our clients require all records at a time
Is there any solution in any newer version of crystal reports?
Even it is acceptable for me, that somehow I just start printing the report, and then it takes time so it is acceptable. But at this time I can’t print the report.


Replies:
Posted By: hilfy
Date Posted: 06 Mar 2012 at 5:30pm
What kind of data is in the child sub-reports?
 
For EACH time a subreport is called, Crystal connects to the database and runs a query.  If you're calling 4 subreports 30000 times (the number of records in your main report * 4 subreports) that means that Crystal is connecting to the database or your datasets 150000 times to run your report.  This is what is slowing things down.
 
Unfortunately, I don't think there's any way around using the subreports unless the users change the layout requirements.
 
-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: Asif Sharif
Date Posted: 06 Mar 2012 at 10:25pm
Thanks for reply

Posted By: lockwelle
Date Posted: 07 Mar 2012 at 3:21am
well....
 
here's a thought, as it removes the connection to the database, but only works from an application.
 
have your application gather the data into the dataset, so that everything you need for the report and all the subreport is in the dataset, then 'push' the dataset to the report.  This results in 1 call to the db and CR will process the file...it might still take a while to process, but it removes the vast majority of the calls to the database.
 
For the report, the report source is Ado.NET.
 
If nothing else, it is worth a try.

Posted By: Asif Sharif
Date Posted: 07 Mar 2012 at 3:47am
Thanks for your suggestion, but i am already using your suggested model, if it is not possible to increase processing time,i just want somehow i print the report

Posted By: lockwelle
Date Posted: 07 Mar 2012 at 3:56am
subreports are still slow, regardless of how they are called...
I try and avoid subreports.  If I have all the data, I usually return a really wide record to the report, then it is just a matter of conditional suppression and grouping to replicate the subreport information
 
Yes, I realize that this is not always possible, but I think in the majority of cases it is.  I've written my fair share of medium to complex reports (at least I think they are...who knows) and out of those the ones that I needed a subreport I can count on 1 hand, and they were usually just because I needed A VALUE to populate, not a whole report (and I hated that I could determine a better a solution).
 
Just trying to think, and I missed Hilfy's comment about connecting to the datasets...which is basically swapping out what CR is reading at the time...which of course takes time.
 
The only other thought that came to mind is to put the subreports in different versions of the same band (detailA, detailB, etc) and conditionally suppress them if they are not needed (and you can tell this without calling them)
 
HTH
 
 

Posted By: Asif Sharif
Date Posted: 07 Mar 2012 at 4:13am
thanks again for your suggestion, but i have to show both sub reports every time.

Posted By: lockwelle
Date Posted: 07 Mar 2012 at 4:26am
ok, that only leaves trying to reduce your dataset to one large table, otherwise, it would seem that you won't be able to accomplish your goal of printing.
 
not that transforming the report is a guarantee of success, it is just the only way to remove the subreports from the report which are slowing it down.
 
I guess there is the option to only increase the 'main' data a little, enough to encompass one of the subreports, which might allow the report to complete as you just removed 30k of switching
 
it's a thought

Posted By: Asif Sharif
Date Posted: 07 Mar 2012 at 4:37am
thanks for your valuable time, but my report design restrict me to use sub reports, yes you are right that sub reports can be merge in main reports and we use group for it, but here i require some child records should display in parallel which i can't achieve with out sub reports


Print Page | Close Window