asked on

Crystal 2008 report not refreshing data updates

I have some Crystal Reports 2008 that are looking at an online Quickbase database. I am experiencing some data refresh issues.

Issue:
New records show up immediately upon report refresh. Updates to current records only show up if I completely close and reopen the entire Crystal program, OR if I create a new report looking at the same data while the old report is open. It does not help to just close and reopen the report.

How does Crystal store its datasets for refresh?

Thanks for any help.

vasto

This looks more like application issue, not Crystal issue. What kind of software are you using to run the reports ?

Methos

ASKER

I am using crystal reports 2008 - opening an rpt file, no other software.

Methos

ASKER

I take that back - I am using Quconnect to create the odbc connection.

However, I use that same connection to view the data with a linked table inside MS Access and I see the changed data in the table.

Mike McCracken

How are you updating the data?

mlmcc

Methos

ASKER

Usually via the Quickbase interface, but also via the linked table inside Access. I see edits from QB in the linked table, and edits from the table inside QB.

Mike McCracken

Are you reporting from Quickbase or the Access linked tables?

mlmcc

Methos

ASKER

I have tried both - and this happens whether I link directly to QB or via the linked Access table.

Mike McCracken

Do you have data saved with the report?

mlmcc

Methos

ASKER

No, I don't have saved data checked. I have been using these reports for over a year, this the first time I am noticing this behavior.

Odd thing I noticed... I open Crystal, open a report, data looks correct. Then I change data in a record and press rpt refresh - data change is not picked up. However, if I completely close Crystal and reopen the rpt the data change shows up.

Also, when I have a rpt open, change data, see the rpt not refresh - and then create a brand new rpt... The new rpt sees the data change and then refresh if the original rpt will show data change.

So I wondered if Crystal creates a data cache upon opening or a new rpt being created.

Also wondered if something in the Crystal options could be causing this.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Methos

ASKER

It is a standalone version. I will check on the service pack once I am back in the office - a good thought.

Methos

ASKER

I have CR Developer 2008 - version 12.2.0.290. It says there are no program updates, and I have auto update turned on.

From what I can tell, that version is equal to SP2 for CR 2008 - and the SP's for this version go up to newly released 7. I am working on downloading SP7. Will let you know how it goes.

Thanks.

habibb

Try to use:

Report.DiscardSavedData

also try to use:

crystalReportViewer1.RefreshReport();

Thanks
Atiq

Methos

ASKER

I upgraded to a newer version - Crystal 2013. It seems to be working fine now.

Thanks everyone.