This is a weekly summary of all survey responses, emailed out in excel on Sunday evening for the previous week. For those running multiple surveys, enter "Yes" in variable X to use the recipients specified in the survey alert process i.e. ID109, ID220, ID312, etc.
There is an on demand SSRS report that is run direct from the SSRS reports folder, allows you to filter by branch, specific survey and # of days to look back for results. Defaults to 7 days, if you select 30 it will look back 30 days from today and report all responses.
Please note, if you use Variable X option, then the To/CC/BC will NOT work.
Sample of Excel attachment in email:
On demand SSRS Report: