HOW to report individual responses to each quiz question in a Storyline project

Hi Dominique,

We are on SumTotal 8.9.3 and we capture our Storyline quiz data and use it for reporting purposes, but we do it mostly on the back end.  There are certain tables in the database that keep this information.  You should be able to access them using Report Manager and the Assessment dataset.  If you use BIDS to do your reports it's easier to get to the data.  Accessing it via SQL Server Management Studio is even easier.  Below is an example of a query I use to retrieve the data.

SELECT [AssessmentQuestionID], emp.PrimaryJobName, emp.EmpNo, emp.EmpFName, emp.EmpLName, act.ActivityName, [QuestionID], QuestionIdentifier, ques.QuestionText, [QuestionResult], [UserResponse], [AttemptCount], [TimeSpent], [ElapsedSeconds], [AttemptStartDate], [AttemptEndDate]

FROM [S0PLRCDW].[dbo].[factAssessment] fact

INNER JOIN [S0PLRCDW].dbo.dimActivity act on fact.ActivityID=act.ID

INNER JOIN [S0PLRCDW].dbo.dimUser emp on fact.UserID=emp.ID

INNER JOIN [S0PLRCDW].dbo.dimQuestion ques on fact.QuestionID=ques.ID

WHERE (act.Code='nnnnnnnn')

ORDER BY AttemptStartDate,QuestionIdentifier

This gets me all the information I need for our business areas.  You just have to make sure that whatever quiz or survey you want captured shows up on the results slide.  We've done a pre-test and post survey in the same course along with the course content and built a custom results slide with them all on there and they all showed up in the data.  I've attached an example of the data we can pull.

Hope this helps.

Have a great day!

James