Display column values in single row.

[pathfinder2104.work]

Hi,

I have a report where I want to display items in a shop in a single comma separated string, Right now in my report I am using a list element to fire a query and fetch all the list of items so it fetches all the items but these items are displayed on a separate line each time. I want to display them in a single row in a comma separated manner.

Current display status:

item1

item2

item3

item4

What I want is ::

item1, item2, item3, item4

P.S I tried using concat() on this item column, I tried using the HORIZONTAL print it helps in printing them in the way I want but theres too much of space in between and sometimes some of the values are not fully printed.

[ducan9]

What do you mean by "using a list element to fire a query and fetch all the list of items"? Give example code.

[pathfinder2104.work]

Well I am using a list which has its own dataset and I get all the values but all are in a separate line, I want to combine them all and then want to represent it as a single string with comma separated items.

[hozawa]

Just define a variable. Set initial value to "" and expression to $V{variable_name} + $F(field_name}

You'll probably want to add conditional to add sepators between fields.