I would like to automate creation of a report where the report would be automatically created on a dialy basis without human interaction.  The job would run on one of our servers.  Is the best approach to create a scheduled task and programmatically create the report and then have the task save off the results?
Thanks for your help!