We have record producer on hr case that has multi row variable set with variables 1,2,3. Now we want to create a report on this multi row variable set, for this we have created database views using 'sc_multi_row_question_answer ' & 'sn_hr_core_case' tables. We are getting each variable in a separate row, but we wanted to have all variables along with Hr case number in a single row. Is there anyway who already have achieved it?
| | Hr case | Variable1 | Variable 2 | Variable 3 |
| | | | | |
