pathfinder2104.work Posted March 20, 2014 Share Posted March 20, 2014 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:item1item2item3item4What I want is ::item1, item2, item3, item4P.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. Link to comment Share on other sites More sharing options...
ducan9 Posted March 20, 2014 Share Posted March 20, 2014 What do you mean by "using a list element to fire a query and fetch all the list of items"? Give example code. Link to comment Share on other sites More sharing options...
pathfinder2104.work Posted March 20, 2014 Author Share Posted March 20, 2014 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. Link to comment Share on other sites More sharing options...
Solution hozawa Posted March 21, 2014 Solution Share Posted March 21, 2014 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now