• I have used SSRS report subscriptions to send renderings of reports places on a schedule. This would help satisfy the requirement to send the report to your users on a schedule, however I am not sure how easy it is to setup or change these schedules programmatically so the requirement to allow your users to change this schedule to suit may not be simple to handle. I always setup the schedules through Report Manager if the users requested to receive the report at a new time.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato