This is a weekly summary of all survey responses, emailed out as an Excel spreadsheet 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 can be run directly from the SSRS reports folder. It allows you to filter by branch, specific survey and number of days to look back for results. It defaults to seven 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: