We have upgraded recently from Crystal 11 to Crystal 11 R2. When our users navigate between pages in the Crystal Reports Viewer, the stored procedure used as the data source is being called each time thus causing delays between pages. This was not the case in Crystal 11, the stored procedure was called once and page navigation was very fast.

It's like 11 R2 no longer caches the already retrieved data set.

Does anyone have a solution to this issue?




Edited by deanaoyama - 19 Apr 2012 at 11:51am

I had a similar problem.