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 wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report not getting Refreshed while using Query file ...

Status
Not open for further replies.

Ajith2002

Programmer
Jul 16, 2002
30
US
I am using a query file to generate a Report. The report is not getting refreshed once when I update the data. It's getting refreshed only when I change the name of the query file, and have to point to the new query file through Database/Set Location. Why is it so ? How do we fix this ?
I'm using CR8.

Thanks very much.
 
When you save your .qry file, you have to uncheck "Save Data With Query" in the File menu of he SQL Query Designer. For some reason, Seagate thinks that "save data" should be the default and thoughtfully checks it for you whenever you run the query in the Designer. If data is saved with the query, the report based on that query will not refresh.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top