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 "Save Data with Query" 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-
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.