Breaking TextField content

0

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 C
INNER JOIN DOCUMENTO D ON C.CD_CLIENTE = D.CD_CLIENTE
GROUP BY C.CD_CLIENTE 

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:

mesaquenascimento's picture
Joined: Nov 5 2013 - 4:01am
Last seen: 4 years 6 months ago

1 Answer:

0

Can you post an example (better if you can post a screen shot), we may solve it . Any questions AT: su.man@aol.com

su.man's picture
14
Joined: Feb 25 2013 - 2:55am
Last seen: 3 months 3 weeks ago

I've added an image to illustrate the final look of the report.

mesaquenascimento - 6 years 1 month ago
Feedback