Hello
I am trying to make a report where two of the fields can have simultaneous multiple values. E.g. a study can be sponsored by one or more companies.
I'm trying to have my report list these multiple values. Instead, a new line in the report, with all the data, is created.
Here's what I'm trying to see:
StudyID Sponsor Start End Measurements
113 NHL Jan 2007 Oct 2008 Customer Satisfaction
NBA ROI
Ticket sales
But this is what I'm getting:
Hello
I am trying to make a report where two of the fields can have simultaneous multiple values. E.g. a study can be sponsored by one or more companies.
I'm trying to have my report list these multiple values. Instead, a new line in the report, with all the data, is created.
Here's what I'm trying to see:
StudyID Sponsor Start End Measurements
113 NHL Jan 2007 Oct 2008 Customer Satisfaction
113 NHL Jan 2007 Oct 2008 ROI
113 NHL Jan 2007 Oct 2008 Ticket sales
If anyone knows how to fix this, please let me know!
Thanks in advance.