Sounds like you're on the right track. Have the routine run after midnight, do a find, and loop.
If you want a report, you're going to run into the annoying fact that FMS can't create a pdf from a script. As alternatives, though, you could compile the details of the report as text and send that, or if you're sending it to yourself (or another FM user) you may want to consider emailing yourself a snapshot link.
We overcome FM Server's limitations by installing Filemaker on the server and starting a unshared database on the desktop which onFirstWindowOpen calls any script we might like from the hosted solution, with no limitations.
We start the starter database via the free Task Till Dawn.