Solved

crystal reports viewer refresh

Posted on 2010-09-07
14
1,124 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
Comment Utility
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
Comment Utility
Woah, sorry for the bad grammar in previous post. I've just now had my morning coffee. ;-)
0
 
LVL 8

Expert Comment

by:kingjely
Comment Utility

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
 

Author Comment

by:JP_TechGroup
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
What Is Threat Intelligence?

Threat intelligence is often discussed, but rarely understood. Starting with a precise definition, along with clear business goals, is essential.

 
LVL 8

Expert Comment

by:kingjely
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Yes, several of them have a Crystal 2008 version.
0
 
LVL 26

Expert Comment

by:Kurt Reinhardt
Comment Utility
Great, thanks Ido!

~Kurt
0
 
LVL 12

Accepted Solution

by:
GMGenius earned 500 total points
Comment Utility
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

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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 …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video discusses moving either the default database or any database to a new volume.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

762 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

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now