Say you had a nice portlet and the users wanted to received the data every day without any user action.
I'd rather do it with a portlet than with a report.
Doing it the hard way would be running the query in a process and creating an xml file like Export Excel data only format out of it and storing the file and then retrieving it as an attachment to the emails.
Any shortcuts? Like putting the content of the file into the body of the email or constructing the body to be a table format of the data content only without the xml tags or maybe with html table tags.
Using search scheduled Export to Excel or scheduled portlet did not bring anything helpful.