I have a report that only uses one table. By default our database index for this table uses dates as its main index and I assume Crystal Reports duplicates this, however, it makes the report extremely slow to the point of freezing/not working. If I take away the date filters from the SQL query then the report gets produced much faster.
Is there anyway that I can continue to use the date range in its sql query but prioritse another index field over this in crystal? I have tried re-arranging the sql query to put the date range at the very end but it doesn't make any difference. Also, I tried adding grouping/sorting of other index fields above the date field but also to no-avail.
Anyone know anything else I can try? Thanks in Advance!
Edited by nix1016 - 26 Jun 2011 at 10:57pm
IP Logged
