melanie.masse Posted January 6, 2017 Share Posted January 6, 2017 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. Link to comment Share on other sites More sharing options...
taepoop12 Posted January 7, 2017 Share Posted January 7, 2017 your english makes my nose bleed Link to comment Share on other sites More sharing options...
taepoop12 Posted January 7, 2017 Share Posted January 7, 2017 put another FIELD ELEMENT and then USE the name of the FIELD that u want to display again Link to comment Share on other sites More sharing options...
melanie.masse Posted January 8, 2017 Author Share Posted January 8, 2017 I'm sorry for you that English is not my native language!!If you can help me, please feel free to give me a solutionif you still have stupid answer to say, please feel free to go away Link to comment Share on other sites More sharing options...
melanie.masse Posted January 8, 2017 Author Share Posted January 8, 2017 I already put to field with the same name ($F{comment}) and show me the same values Link to comment Share on other sites More sharing options...
hozawa Posted January 8, 2017 Share Posted January 8, 2017 First, iReports is now obsolete. It's not being developed nor supported. You should be using Jaspersoft Studio instead. Not sure about your question, but did you place $F{comment} in the details bands? Link to comment Share on other sites More sharing options...
melanie.masse Posted January 8, 2017 Author Share Posted January 8, 2017 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 Link to comment Share on other sites More sharing options...
sanbez Posted January 9, 2017 Share Posted January 9, 2017 Add another field from table evaluation into report to check the result of execution sql-queryAnd show jrxml and result of execution.It is so hard to undestand error (in report? in query? in textfield?) without jrxml...For instance you wrote that count of record from sql-query=3But in screen presents only 2 records:tewlawtetewlawteWhy? Link to comment Share on other sites More sharing options...
melanie.masse Posted January 9, 2017 Author Share Posted January 9, 2017 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.PNGThe 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).PNGMy JRXML where comments are :/sites/default/files/images/commentJRXML.PNG Link to comment Share on other sites More sharing options...
melanie.masse Posted January 9, 2017 Author Share Posted January 9, 2017 I finaly find a way in sql with GROUP_CONCAT(comment SEPARATOR 'n') as commentaires 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