Hi Rich,
We are all excited from the new v5.4 to be released this weekend that is going to support this exact use case.
There is a new ability with business rules to have an action that send a report automatically, so embedded with a scheduled workflow, the request above can be easily achieved.
Great question :)
Rami