Compare against a list and email if variance

[ckrusen (Calvin Krusen)]

The easiest way would be to make a BAQ report, and submit it on a schedule with email as the output (as opposed to printing or previewing).

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. …