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.