Just like for each that populate several rows in Excel Template, can we do the same for columns?
Summary:
Hello,
For the Recruiting module, our client wants to have a report that dynamically populates the Questions found in Questionnaires of Job Requisitions based on a Country (country to be used as parameter). Some Job Requisitions can have 5 Questions while some may have 10. The report already have around 25 columns + the questions. (Repeating Group for columns)
Content (required):
We prefer not to use RTF template as the number of columns makes it difficult to have a proper layout design. We are trying to use Excel Template to populate the questions and answers. For example if country X has 3 Job Requisitions will a total of 20 questions (10 in first job req, 5 in second and 5 in third) we wish to populate 20 columns in the Excel Template with the Question Text as header and their respective answers. See attached screenshot for more details. Is this possible?