Options for Showing Multiple Values in Grid

Applications Grid / Reports
#1

Currently in my grids, multiple values are shown with a BR separator (showing a line break). Consequently, all Excel exports also show multiple values with a BR tag between the values, which, of course, shows as an HTML BR tag in Excel. Is there any place that I can specify to delimit multiple values with something other than a BR tag in a grid? I would like to use comma space (, ) in most cases, but can not find any options in the application, nor figure a way to do it using a macro or PHP.

Thanks for any input on this.

#2

In microsoft sql server you can use this:
http://sqlandme.com/2011/04/27/tsql-concatenate-rows-using-for-xml-path/

#3

Thanks for the link. I need to find a way to do this after the SQL - during the ScriptCase processing.

#4

You are welcome.