<p>Desinging web application and for reporting iam using crystal reports.sometimes the crystal reports gives runtimes error. What can i do to make my report faster. Retrieving around 1MB of data. It is the month end sales report. what is the best method to solve this issue.</p>

1Mb sounds like far too much data for a report -
I would try to filter it down more on the server