OTBI Prescreening Questions as column headers - Prescreening Questions OTBI Report
We have had a requirement to produce a prescreening questions OTBI report. The subject area has a column for Question Text and a few for the responses.
The issue is they've requested the questions be the column headers and responses be the rows. Has anyone achieved this or handled a similar requirement? I've looked into doing it using a CASE WHEN statement which does work but seems a huge manipulation of the functionality - is there a better way to achieve this?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):