Data Retention Issue

[SelectStar]

We are seeing a sporadic issue when we run a batch of reports, where Crystal 8 will fail to refresh its data on consecutive reports. In other words, the data from the previous report will appear on the new report. The reports are not set to save data. This has been seen several times with graph generation, though not exclusively. This will happen on about 5 out of 100 reports. Has anyone seen this? Is there a viable workaround?

 

[Naith]

I don't know if this is related at all, but the only thing I have seen reminiscent of this is a report which, when refreshed, would return no data. If you refreshed it a second time, data would be returned.

It turned out the query was corrupt. A new query was created in designer (save data with query; off), the old one deleted, new query renamed to the same name as the old one. When the report was run against the new query, it was fine all the time.

Naith