crystal reports viewer refresh

I have a Crystal Report written in Crystal 2008 that uses SQL commands to connect to an access dbase via ODBC. The viewer will open the report and display the saved data in it, but it will not update to show changes to the Access dbase. In other words, if I add a line to the dbase, the report does not update to show the added information. Can someone tell me what I may be doing wrong?
LVL 1
JP_TechGroupAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
GMGeniusConnect With a Mentor Commented:
Thank you... this begs the question, is there a report viewer out there that will allow the report to refresh and show the changes from the database?
Yes, look at EasyView, its cheap and it works very well
http://www.easystreetsoftware.net/Products/EasyView_Main.php
or even
http://www.saberlogic.com/crystal-reports-consulting/crystal-reports-viewer 
0
 
LinInDenverCommented:
It sounds like you are using Crystal Reports Viewer, the free viewer the SAP provides, which it sounds like this is what you are using.

If so, are you re-exporting the RPT file before opening it in Crystal Reports Viewer? Files viewed in the viewer are a "data saved with report" view, and won't update automatically if the data changes. The report would need to be re-run in Crystal Reports, exported as RPT and then viewed in the Viewer.
0
 
LinInDenverCommented:
Woah, sorry for the bad grammar in previous post. I've just now had my morning coffee. ;-)
0
Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

 
kingjelyCommented:

Hi you may need to go

<Database tab>
<Verify Database>

If that doesnt work, go to

<database> tab again
and log off, and log back on to the server.




0
 
JP_TechGroupAuthor Commented:
So, the report viewer will only display saved data? What the heck good is that?!!!
OYE!
Ok, breathing again...
If that is the case, why does it have a refresh button at the top of the screen?
0
 
LinInDenverCommented:
Hi JP - the viewer allows your users to "drill down" and navigate reports similar to how you can as the designer, where they would not be able to do this in Excel or PDF, etc.

I'm not sure on the refresh button - I never was able to get it to work. I figured it was for developers hooking into the viewer that had the ability to refresh on the fly. Hopefully someone else knows that answer.
0
 
kingjelyCommented:
make sure

If you go to
<File>
Is
< save data with report> checked?

Have you tried to verify Database yet? then refresh your report?

0
 
JP_TechGroupAuthor Commented:
These aren't options that I can find on the Viewer...
To the best of my knowledge, these are only available in Crystal Reports itself. Am I missing something?
0
 
kingjelyCommented:
Ahh No, I think Lin must be onto something, I have never used the Free Version OF crystals, or seen it,
Sorry I didn't realise.

Thats how you would do it if you had Crystal Reports.. Sorry mate, i don't think i can help on this one ;)
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Think of the Crystal Reports Viewer 2008 as being similar to the free Adobe Reader. It's purpose is to allow a user to view a Crystal Report without requiring a fully licensed copy of the Crystal Reports 2008 designer, just like Adobe Reader allows a user to view a .pdf document without requiring a fully licensed copy of Adobe Acrobat.  A perfect use of this tool would be for external users or customers to which you've distributed reports.  As an example, I can download a .pdf of my monthly natural gas bill.  Imagine if it was a .rpt file, though, and I could actually drill down into my usage charts, filter or resort the results dynamically, etc..?  That would be much more functional.  If you have an enterprise system and burst reports out to external clients, they could greatly benefit from the viewer.

As to why there's a refresh button - users are allowed to refresh data if they're connected to a repository (BusinessObjects Enterprise, BusinessObjects Edge or Crystal Reports Server) and have the appropriate permissions and database credentials.  This is a redundant feature, however, since the same user could simply login through the portal (Infoview) and do the exact same thing through a web browser without requiring a desktop client.

Here's an example of a Crystal Reports 2008 report designed to be consumed in a viewer by an end user.

https://www.box.net/shared/szco23gb80

~Kurt
0
 
JP_TechGroupAuthor Commented:
Thank you... this begs the question, is there a report viewer out there that will allow the report to refresh and show the changes from the database?
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Definitely - check out this link on Ken Hamady's page:

http://kenhamady.com/bookmarks.html

FYI - I don't know if any of them are compatible with some of the newer Crystal Reports 2008 features.

~Kurt
0
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Yes, several of them have a Crystal 2008 version.
0
 
Kurt ReinhardtSr. Business Intelligence Consultant/ArchitectCommented:
Great, thanks Ido!

~Kurt
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.