Reporting on candidate screening question answers

Summary:

We are trying to use OTBI to report on specific screening questions used in the external app flow. However it is timing out for the end user and it is also timing out for the reporting team. I am conscious that we are working one using the “Question Text” column for the “Sourcing” drop down and as this is failing in a simple report

The report is built using the subject area: "Recruiting - Recruiting Real Time" and should work fine but we keep on getting the same error even if I reduce the data down which slows the whole report down even more it seems.