April 30, 2008 at 3:27 am
Hi,
In our project we had crystal reports. One crystal report is taking 3 min to load.For that crystal report 11 sub reports are binded. We are using stored procedures for the reports.One stored procedure is taking 30 sec to execute. Total stored procedures are taking 1 min 20 sec to execute. Full report is taking 3 min to load.
Please provide a solution to improve the efficiency of the crystal report.
Your help is much needed.
Regards,
Srinivasa:)
April 30, 2008 at 3:39 am
This is not really DTS, but what the hey....
You must understand that eleven sub-reports are going to take some time to load the data from the procedures and apply the formatting.
To increase performance make sure that your subreports are bound on as many parameters as possible. Also, make sure that you really need eleven sub-reports; it does seem a little excessive.
You may be able to produce the required data in a SQL stored procedure and then simplify the Crystal side of things.
HTH,
April 30, 2008 at 4:28 am
Hi,
All the subreports should come under one single report. All these subreports are under single big report.Procedures are taking 1 min 15 sec to execute and whole report is taking 3 min to load.
Please provide the answer ASAP.
Regards,
Srinivasa
April 30, 2008 at 4:39 am
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply