Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Database refresh

Status
Not open for further replies.

cc5305

MIS
Oct 4, 2000
70
US
I have a report running based on a SQL written in SQL Designer. However, when I can the data in the database, the report does NOT refreshes the data when I preview the report. Is there some settings I did not set right? [sig][/sig]
 
The option
File|Save Data with Report
may be checked, which would create this type of problem.
Report|Refresh Report Data, or use the Refresh button, or hit F5 are other ways to refresh the data.
Because there are so many ways to refresh data, you can correctly assume this is an important part of the reporting process. [sig][/sig]
 
There is also a setting for &quot;Save Data with Query&quot; which is set by default in the SQL designer. Take this setting off and save the QRY file again. This will force the report to rerun the query. [sig]<p>Ken Hamady- href= Reports Training by Ken Hamady</a><br>[/sig]
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top