Announcement

Collapse
No announcement yet.

Options for Showing Multiple Values in Grid

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Options for Showing Multiple Values in Grid

    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-...-for-xml-path/

    Comment


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

      Comment


      • #4
        You are welcome.

        Comment

        Working...
        X