Im trying to create a report that its number of columns vary depending on which company it is based on. Does anybody know if it is possible?
For example.: Say we have 4 companies who require reporting on their customers who ring up and answer questions during an interview. Each company will have a different number of questions and therefore each company will require a different number of columns as the users would like the report to be set out as :
Company Name Company Code Question 1 Question 2 Question 3
Company 1 CC1 Answer 1 Answer 2 Answer 3
At the moment i only know how to show the questions and answers in row format as this is simple using the group option but we rreally need to be able to show it in the above format.
Can anyone Help?