Solved

crystal reports viewer refresh

Posted on 2010-09-07
14
1,156 Views
Last Modified: 2012-05-10
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?
0
Comment
Question by:JP_TechGroup
  • 3
  • 3
  • 3
  • +3
14 Comments
 
LVL 14

Expert Comment

by:LinInDenver
ID: 33618687
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
 
LVL 14

Expert Comment

by:LinInDenver
ID: 33618694
Woah, sorry for the bad grammar in previous post. I've just now had my morning coffee. ;-)
0
 
LVL 8

Expert Comment

by:kingjely
ID: 33618725

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
3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

 

Author Comment

by:JP_TechGroup
ID: 33618752
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
 
LVL 14

Expert Comment

by:LinInDenver
ID: 33618784
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
 
LVL 8

Expert Comment

by:kingjely
ID: 33618797
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
 

Author Comment

by:JP_TechGroup
ID: 33618854
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
 
LVL 8

Expert Comment

by:kingjely
ID: 33618957
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
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33619216
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
 

Author Comment

by:JP_TechGroup
ID: 33619245
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
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33619306
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
 
LVL 22

Expert Comment

by:Ido Millet
ID: 33621217
Yes, several of them have a Crystal 2008 version.
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
ID: 33621301
Great, thanks Ido!

~Kurt
0
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
ID: 33621311
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

Featured Post

3 Use Cases for Connected Systems

Our Dev teams are like yours. They’re continually cranking out code for new features/bugs fixes, testing, deploying, testing some more, responding to production monitoring events and more. It’s complex. So, we thought you’d like to see what’s working for us.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

821 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question