Crystal Reports takes much time while loading viewer in production server. We are tried on various techniques to improve the performance of the reports but it all not improves up to optimize level. We are used the stored procedures for our reports. One of my senior colleague gives a solution for performance improvement for crystal Reports.It work fine after doing below steps.
Open your crystal report in Crystal report Studio
- File Menu–> Report Options –>Uncheck the below options
- Verify on first Refresh.
- Verify stored procedures on First Refresh.
- Save Data With Report.