Friday, March 23, 2012

Refresh of Data in Crystal Report

Hello,

I'm developing Crystal Report and data is being fetched using Query. Now each time I "run" report, I get stale data. I tested query several times and that is working fine.

I also checked that,

1. File->Report Options-> Save Data with Report is UNChecked.
2. File->Options->Reporting->Save Data with Report is UNChecked.
3. File->Options->Reporting->Discard Saved Data while Loading Report is Checked.

Whenever I open report, I only see Design tab and no Preview tab. however, on running report, I get stale data. Please let me know if you know solution to this problem.

Thanks a lot in Advance,
Regards,
RupeshI am having a very similar problem. I just gave one of our users a new computer. She was running windows 2000 and she is now running windows xp. I installed crystal reports for her and imported all of her ODBC settings from the old computer to the new computer. There are two crystal reports that when she opens them, it only shows the "design tab", but no "preview tab". When I go back and open those two reports from her old computer, they open fine. I see that nobody responded to your post. Did you ever find a solution to the problem?

Thanks - Jeff|||Rupsan,
What do you mean by stale data?
Also what Ver are you using?

Texasman,
The reason your preview tab does not show up is because the savedata box is not checked in report options.|||ya exactly dear when you uncheck the save data you don't find any preview tab if you want preview click on print preview in report you will find it.

and rupsan i also don't understand what stale data means.

thanks|||I have the same issue. I have unchecked (and checked) the appropriate boxes as did the OP. On open, I do not get a preview tab (This is what I expected). However, on refresh the data on my report is last weeks data. I looked directly at the data table and there have been several additional entries that are not shown on the report. I have disconnected and reconnected to the databse, all to no avail. Can anyone figure this out?? Thanks.

No comments:

Post a Comment