Nightly SSRS Email Report

You don’t even need Break/Routing (although it makes it easier).

Just run the report like you were going to print it or preview it. But set a schedule and make it recurring. And instead of clicking the Print or Preview Icon, click the email one. Then fill in the info in the email setup.
NOTE! - hitting the enter key while typing in the Email Body field is the same as clicking the OK button.

When you do click the OK button the task goes to the scheduler and will run at the prescribed time.

You would need Break/Routing if you wanted fileds like the To: or Body: to be dependent on the content of the data (like only sending copies of orders to salesmen specified on the order).

5 Likes