We help IT Professionals succeed at work.

Crystal 2008 report not refreshing data updates

Methos
Methos asked
on
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.
Comment
Watch Question

Top Expert 2011

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

Author

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

Author

Commented:
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 McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
How are you updating the data?

mlmcc

Author

Commented:
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 McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Are you reporting from Quickbase or the Access linked tables?

mlmcc

Author

Commented:
I have tried both - and this happens whether I link directly to QB or via the linked Access table.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Do you have data saved with the report?

mlmcc

Author

Commented:
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.
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Crystal will cache data for the sake of speed but if you click REFRESH it should hit the database.

Is this the standalone version of CR 2008?
Have you installed the latest service pack?
http://scn.sap.com/docs/DOC-27917

mlmcc

Author

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

Author

Commented:
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.
Top Expert 2007

Commented:
Try to use:

Report.DiscardSavedData

also try to use:

crystalReportViewer1.RefreshReport();


Thanks
Atiq

Author

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

Thanks everyone.