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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
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
Determine the Perfect Price for Your IT Services

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden with our free interactive tool and use it to determine the right price for your IT services. Download your free eBook now!

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
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Crystal Reports

From novice to tech pro — start learning today.