Bienvenue, Invité
Nom d'utilisateur : Mot de passe : Se souvenir de moi

SUJET : Survey ID and passing to a SSRS via Paramater

Survey ID and passing to a SSRS via Paramater il y a 1 an 5 mois #95060

  • lime_Chris
  • Portrait de lime_Chris
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
Hi all,

We currently use Sharepoint as a Survey tool, and beeing developing and looking into using Lime Survey as its more light weight more configuarable and can have a MSSQL backend so tables can be indexed etc.

The current process is someone fills out a Sharepoint Survey and writes down the ID.
Then then book a appointment for the customer (writing down the ID) in the appointment.

Later when the appointment is ready (i.e the appointment is now) they look up the ID to view all the responses and discuss with the customer.

We use SSRS (SQl Server Reporting Server) for the appointment booking, and we can pass parameters into those appointments that we decide to book.

So first question is can we see the Survey Response Id thats being filled in? and Display it for debugging on the page.
Then is there a easy way to see all the responses of a Survey? This one is a lesser concern, as we can just create a Report to display all results for XXXX Survey Response Id (Id that is saved into the Survery_XXXXXX table.
Dernière édition: il y a 1 an 5 mois par lime_Chris.
L'administrateur a désactivé l'accès en écriture pour le public.

Survey ID and passing to a SSRS via Paramater il y a 1 an 5 mois #95072

  • tpartner
  • Portrait de tpartner
  • Hors ligne
  • LimeSurvey Team
  • Messages : 4210
  • Remerciements reçus 792
  • Karma: 360
After the first question page is submitted, you can use the {SAVEDID} placeholder to display the record ID.
Cheers,
Tony Partner

Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.

LimeSurvey is open-source and run entirely by volunteers so please consider donating to support the project.
L'administrateur a désactivé l'accès en écriture pour le public.
Cet utilisateur a été remercié pour son message par: lime_Chris

Survey ID and passing to a SSRS via Paramater il y a 1 an 5 mois #95092

  • lime_Chris
  • Portrait de lime_Chris
  • Hors ligne
  • Fresh Lemon
  • Messages : 2
  • Karma: 0
Thanks!

That is perfect just what I am after.
L'administrateur a désactivé l'accès en écriture pour le public.
Modérateurs: ITEd
Temps de génération de la page : 0.130 secondes
Donation Image