Print Page | Close Window

Change or Prioritise Table Index

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2022
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=13604
Printed Date: 22 Apr 2025 at 9:33pm


Topic: Change or Prioritise Table Index
Posted By: nix1016
Subject: Change or Prioritise Table Index
Date Posted: 26 Jun 2011 at 10:57pm
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!


Replies:
Posted By: sharona
Date Posted: 06 Jul 2011 at 6:53am
you need to index on the server.
you have the sp parameterized?


-------------
sharona


Print Page | Close Window