Skip to Content
Former Member
Nov 27, 2009 at 02:43 PM

Report reponse is slow


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!