Thanks for your reply Rahul
I have checked the two options you suggested but this hasn't made any difference to the speed of the report.
I assume using database views will only speed up the retrieval of data from the database?
This report is scheduled to run overnight and so doesn't touch the database when the user clicks on it in Infoview. It just has to render the contents of the report using data that is already there, this is why I don't understand why it is so slow!
I have read that in previous versions of Crystal, that there was an option to save summaries with the report. As the majority of the report running time has to do with 'Compressing Summaries', I think this would make a massive difference. Only problem is, I can't find this option in XI.
Has it been removed or is it just supposed to happen automatically now?