Display column values in single row.

0

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.

pathfinder2104.work's picture
Joined: Feb 27 2014 - 8:52pm
Last seen: 5 years 6 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 - 5 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 - 5 years 11 months ago

1 Answer:

0

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
57680
Joined: Apr 24 2010 - 4:31pm
Last seen: 8 months 1 week ago
Feedback
randomness