Onboarding Report

Summary

BI Publisher Onboarding Report

Content

Hello. We have surveys under Onboarding and we need to report on the results. I have written this in BI Publisher but I am having no success. Has anyone written a report for onboarding survey results?

select distinct per_tasks_in_checklist_b.questionnaire_ID, per_all_people_f.person_number,per_person_names_f.last_name, per_person_names_f.first_name,
hrq_ptcpnt_questions_V.question_text,
hrq_ptcpnt_responses_V.answer_text

from
per_tasks_in_checklist_b,
hrq_ptcpnt_questions_V,
hrq_ptcpnt_responses_V,
per_all_people_F,
per_allocated_checklists,