mesaquenascimento Posted November 5, 2013 Share Posted November 5, 2013 Hello,I have a web project using JasperReports + MySQL.I’ve been searching for a lot and haven’t found nothing like my case.To be clear, I’m a beginer with the iReport tool.I'm developing a report that will show a list of numbers (number of a internal document) grouped by clients.Internaly called by "papelote".Each "papelote" will be formated to fits into a label.the main portion of my query is: SELECT C.NM_FANTASIA, C.CD_INTERNO, GROUP_CONCAT( D.NR_DOCUMENTO SEPARATOR ', ') NR_DOCUMENTO FROM CLIENTE CINNER JOIN DOCUMENTO D ON C.CD_CLIENTE = D.CD_CLIENTEGROUP BY C.CD_CLIENTE [/code]The trouble is:the $F{NR_DOCUMENTO} may return a big String and I need thats fits into the label and if not, create another label with de client data and the rest of $F{NR_DOCUMENTO}, not printed before.I can't use "strech with overflow" because labels has a fixed height.Can anyone give me a light to solve this?(Sorry for my bad english)EDIT:The report needs to look like that: Link to comment Share on other sites More sharing options...
su.man Posted November 6, 2013 Share Posted November 6, 2013 Can you post an example (better if you can post a screen shot), we may solve it . Any questions AT: su.man@aol.com Link to comment Share on other sites More sharing options...
mesaquenascimento Posted November 6, 2013 Author Share Posted November 6, 2013 I've added an image to illustrate the final look of the report. 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