Reports showing stale data

[#1]

Hi there,

I'm using Crystal Reports 2005 in Visual Studio .NET 2005, and have a Windows Forms application that displays a Crystal Report using the Report Viewer control, and pulling data from an access database.

I'm running into an issue where the report I'm trying to display seems to be displaying stale data. My application is saving the information correctly to the database, but occasionally when the report is displayed in the report viewer control, it contains the data from prior to the updates being saved to the database. If I click the 'Refresh' button on the report viewer control, the updated data appears.

I've tried several different options -- calling Refresh() on the report object after instantiating it, calling 'RefreshReport()' on the Report Viewer control, calling 'VerifyDatabase()', etc. All to no avail.

Anyone run into this issue before? Is there a setting that I'm just missing somewhere?

Thanks in advance.

[former_member260594 · Accepted solution]

Craig,

Your question may be better answered in the Business Objects SDK Application Development > .NET forum but if there is a control for Save Data With Report you might want to set that to false. This should force a refresh when the report is viewed

[Former Member · Accepted solution]

Thanks for the response. I'll try there.

At your suggestion I tried making sure that 'Discard Saved Data when Loading Reports' was checked in the designer, as well as setting the same option at runtime in the application. Neither option made any difference, though.

[Former Member · Accepted solution]

FYI, Ludek in the SDK forums did help me get this resolved, for anyone else who happens to stumble upon this thread with the same issue: