I generated a ~.qry file that taps into a database.
I have a report based off of that ~.qry file.
I've been scheduling the report every morning.
First, I open the ~.qry file with SQL designer and then press the refresh button followed by the save button.
I then open my report file and press the refresh button and the save button.
It seems as if I can't automate this every morning.
When I try to schedule the ~.qry file, it does not refresh the data that is why my report file does not schedule with the most current ~.qry data.
Is there a solution?
RycherX
I have a report based off of that ~.qry file.
I've been scheduling the report every morning.
First, I open the ~.qry file with SQL designer and then press the refresh button followed by the save button.
I then open my report file and press the refresh button and the save button.
It seems as if I can't automate this every morning.
When I try to schedule the ~.qry file, it does not refresh the data that is why my report file does not schedule with the most current ~.qry data.
Is there a solution?
RycherX