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.
MethosAsked:
Who is Participating?
 
mlmccCommented:
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
0
 
vastoCommented:
This looks more like application issue, not Crystal issue. What kind of software are you using to run the reports ?
0
 
MethosAuthor Commented:
I am using crystal reports 2008 - opening an rpt file, no other software.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
MethosAuthor 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.
0
 
mlmccCommented:
How are you updating the data?

mlmcc
0
 
MethosAuthor 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.
0
 
mlmccCommented:
Are you reporting from Quickbase or the Access linked tables?

mlmcc
0
 
MethosAuthor Commented:
I have tried both - and this happens whether I link directly to QB or via the linked Access table.
0
 
mlmccCommented:
Do you have data saved with the report?

mlmcc
0
 
MethosAuthor 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.
0
 
MethosAuthor Commented:
It is a standalone version.   I will check on the service pack once I am back in the office - a good thought.
0
 
MethosAuthor 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.
0
 
habibbCommented:
Try to use:

Report.DiscardSavedData

also try to use:

crystalReportViewer1.RefreshReport();


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

Thanks everyone.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.