We need to setup daily emails for all our sales persons. Each recipient should only see their reports. I have the report created containing a TargetSalesPerson parameter but I don't know how to set up the schedule nor the email.
Also can this parameter be set to feed off a table or view so that as we add new salespeople the list gets sent automatically?
I am using SQL Server 2008.