Hi Kelly,
Adding to above suggestion,
Linking to a field in a table that has an index will speed the retrieval of data from the database, so if an indexed field is available, try to use it. An index is created by a database designer or database administrator and can involve a single field or a group of fields. Index arrows are pentagons that are color-coded; the color tells you whether it was the first index created, second index created, etc., It is important to note that indexes are created at the database level and not in Crystal Reports. Crystal can use only existing indexes.
When linking database tables together, you may link on any field you choose ”there is not a requirement to link to or from an indexed field. For performance reasons, however, you may still want to try to link to indexed fields anyway. You may see improved record retrieval speeds.
--Praveen G
IP Logged
