I have created a report in Crystal XI that takes for ever to complete. Approximately 5 Minutes. My data base only contain 300 and 50 records respectively. How can I speed up my report. The SQL is as follows:
SELECT `'Updated_List_'`.`Firm`, `'Updated_List_'`.`Email`, `'Updated_List_'`.`Type of Appraiser`, `'Updated_List_'`.`Appraiser`
FROM `'Updated List$'` `'Updated_List_'`
WHERE `'Updated_List_'`.`Type of Appraiser`='Residential'
ORDER BY `'Updated_List_'`.`Firm`
SELECT `'2009_'`.`City`, `'2009_'`.`Order #`, `'2009_'`.`Order Date`, `'2009_'`.`Appraiser `
FROM `'2009$'` `'2009_'`
WHERE `'2009_'`.`City`='Chesapeake'
Please help!