1 of 1 people found this helpful
right-click the query, select "new custom report".
go to reports / custom reports and right click this new report, then select "schedule publish"
Thanks - that's almost exactly what we're looking for.
The query, custom report, and the scheduled publishing of the report all work fine.
- when I right-click to manually publish the report, I can choose the file format (pdf, html, etc)
- with scheduled publishing, it is automatically saved as a pdf and I see no possibility to change that.
Ideally we would export it as a csvfile.
PDF only, sorry
Ok, thanks for the reply. Will try direct db to db somehow.