Hey guys, I’m trying to get a dynamic list view in a report.
Basically, it’s a report for a survey app I’ve developed.
Desired outcome: A list of questions and answers, (they are from the same table but are 2 different fields)
I can do this as portal but the problem with the portal view is I have to set manually how many rows to display, from my understanding a list view is better for reporting in any case.
This is what I have done so far
I have a surveyTBL that holds information about the survey (I.e. date, location surveyer etc)
Then I have a QuestionTBL that has the survey questions and answer data.
In the surveyTBL I have a calculation field to list the questions
List (Audit_MD_ALL::Question )
And this will display this list below
Signage & Labelling
Motor room lockable
Lockable Main Switch
But when I try this calculation I only get this List (Audit_MD_ALL::Question; Audit_MD_ALL::Sentence )
Maintenance has been taken over by Kone in the last year.
This is basically the first question and the first answer, but no other questions or answers are listed,
Can you advise how I can do the following
- Separate out the question and answer to format like this
Log Card Maintenance has been taken over by Kone in the last year.
- Get the full list of questions and answers instead of just one