Display column values in single row.



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:





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.

pathfinder2104.work's picture
Joined: Feb 27 2014 - 8:52pm
Last seen: 6 years 7 months ago

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

ducan9 - 6 years 11 months ago

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.

pathfinder2104.work - 6 years 11 months ago

1 Answer:


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.

hozawa's picture
Joined: Apr 24 2010 - 4:31pm
Last seen: 1 year 9 months ago