I have a multi-value text field on a form and have set up a view with the field showing all values, separated by semi-colons. When I extract the data to a database, the field is only coming up with the first value (instead of showing all values). How can I obtain each value in the field so that I can show these on a report?
Subject: Show MultipleValue Field on Report
Hi Jennifer,
You can use @Implode in the view. This will transform the multiple-values field into a string.
See help for more reference and syntax.
Hope this help
Regards,
Stephane
Subject: Show MultipleValue Field on Report
What do you mean by “extract the data to a database”? If you are using a .NET based tool or Microsoft Reporting Services, you can plug in a better data driver that can get to advanced things (such as multi-valued items) directly. See Products A-Z and http://www.propoison.com/reportadapter.