Follow

ID883 - Survey Responses SSRS Overview & Sample

Emails responses after a ConnectWise survey is completed

Jump to a specific section by clicking a link

Overview | Samples | Variables | Alert Functionality | OnDemand Report Filters | Best Practices & Tips |  Related Alerts 

 

Overview

Overview

Sends a PDF report after a survey has been completed and provides an SSRS report to run on-demand as needed. It contains all the answers for that survey and highlights any question that has an answer equal to or lower than the target threshold if one is set. 

These PDF Survey Responses can also be accessed via your SSRS Reports.

 

Run Schedule: Every 15 minutes

Type of Output: PDF Email & On Demand SSRS Report

 

*  *  *

Sample

Sample

Screenshot 2024-11-12 at 12.41.27 PM.png

 

*  *  *

Variables

Variables

There are no variables for this alert.

  

*  *  *

 

Alert Functionality

Alert Functionality

Use the survey subscriptions ID505 for the recipients of the survey results. Recipients listed on the alert ID883 subscription have no effect on who receives the responses, it is our background process. 

See ID505 for an overview on sending the initial survey to your email

https://support.ceojuice.com/hc/en-us/articles/205121380-ID505-Connectwise-Survey-Opt-Out-Overview-Sample

*  *  *

 

OnDemand Report Filters

OnDemand Report Filters

SSRS Report Filters:

Screenshot 2024-11-12 at 12.49.01 PM.png

  • Filter by date of response.
  • Enter Customer Name Contains (doesn't need to be complete, just "contains" part of name).  If you want to run the report wide open to include ALL customers
  • Enter in the customer field: -All customers-
  • Enter in the parent customer number: -include all customers-
  • Authentication ID - IGNORE, this section is for our background process.
  • Select Survey drop-down to select all active CW surveys
  • Filter by tech (all techs will show even if inactive employee to provide historical reference). Be sure your techs have Technician checked off and a Manager Assignment on Employee Record:

Tech__2_.png

 

 

 

 

*  *  * 

Best Practices & Tips

Best Practices & Tips

First time accessing your SSRS Reports? Please see THIS LINK for those instructions. 

 

 

*  *  *

Related Alerts

Related Alerts

ID505 - ConnectWise Survey

 

 

 

Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

0 Comments

Please sign in to leave a comment.
Powered by Zendesk