melanie.masse

I finaly find a way in sql with GROUP_CONCAT(comment SEPARATOR 'n') as commentaires

I'm not sure of what you asking first about add another field, but I put another comment field and formateur field to see : /sites/default/files/images/previewComments.PNG The tree in red circle is my comments field result and yellow it's formateur field!! The end of my SQL query /sites/default/files/images/sql(1).PNG My JRXML where comments are : /sites/default/files/images/commentJRXML.PNG

My goal is to put all the comments in the report, no matter how much they are, so i'm looking in part how I can put it all!! And yes, I put them in detail bands

I already put to field with the same name ($F{comment}) and show me the same values

I'm sorry for you that English is not my native language!! If you can help me, please feel free to give me a solution if you still have stupid answer to say, please feel free to go away

Hi, I'm using ireport designer 5.6 and I have to insert comments in a report, maybe using the same $F{Field} Name. It's possible? Right now, it's display the same comment. The comments came from a database. Maybe with a loop or something? Went I do my Query in SQL, no problem, i see what I want.... Here, looking for comment and send me 3!! But how can I see these in iReport since when I call them, I only see the first one? I'm sorry if I'm not sure how it's work since I didn't use iReport before and not using a lot much of MySQl since I just restarted newly.