Jump to content
We've recently updated our Privacy Statement, available here ×

Breaking TextField content


mesaquenascimento

Recommended Posts

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:
REL_DESIGN.jpg.81ca3be9ace9051470bb4c4cca8ce68b.jpg

Link to comment
Share on other sites

  • Replies 2
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Posted Images

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 account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...