I've a client who wants to pick up their reports each day for archiving purposes. I can see an option in the settings for when the cron will be run (time) and then on my sql reports there's an option "Auto run daily: Schedule this query to run each day (At night)". I can't find any clear documentation on this option. The "send_emails.php" file in the block plugin folder is also confusing - where is it used (if at all) ?
Ideally I'd like the report to generate a file (e.g. XLS) and then send it to a specified email address (ideally configurable but I could hard code it too).
The other option is to generate the file (again, XLS) onto some known location on disk and the client can organise a ftp pickup or whatever. This doesn't look to be a feature either.