Report taking too long to run when using command a
Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=21184
Printed Date: 01 Jun 2024 at 4:01pm
Topic: Report taking too long to run when using command a
Posted By: Busi
Subject: Report taking too long to run when using command a
Date Posted: 24 Nov 2014 at 10:56pm
I have a report developed using Crystal Reports XI and i have embedded SQL a statement in a command. The problem I am having is that the report is now taking a very long time (15mins+) to run but the other version of the same report which makes use of tables only is very quick (1-2mins).
Am I doing something wrong? What should I do correct this
|
Replies:
Posted By: z9962
Date Posted: 25 Nov 2014 at 12:35am
|
Are you using tables and commands, then joining these in Crystal?
|
Posted By: Busi
Date Posted: 25 Nov 2014 at 7:00pm
|
Yes, i have just one table that i am joining to the command
|
Posted By: z9962
Date Posted: 25 Nov 2014 at 10:45pm
|
As soon as you join a table to a command your local machine needs to do all the work, can you add your table into your command?
|
Posted By: Vimal Nair
Date Posted: 27 Jan 2015 at 12:23am
Take out the Table from your report and join that table in your main query itself. So that the whole sql will execute in single run and fetch records to your report. Also check the kind of Data connectivity you are using for the report. Doing joins at the crystal report level takes more time for huge no of records than a direct query fetch.
-------------
Born To Live
|
|