CODEWITHSUNDEEP
jasper-reports
user2111815
user2111815

Reputation: 151

How to show several fields values in one textField

Can nay one help to add multiple DB field values in one field.

Say i have 3 DB fields:

Name
Address
Age

I want to display all 3 fields in the same field:

John Peter 28.

I tried doing 3 fields next to each other and it did work but when i wrap text. It looks really bad:

Name

Jo.pe.28
hn te
   r

My requirement is show data in one text field, for example: John.Peter.26

Upvotes: 10

Views: 32363

Answers (2)

Gopinagh.R
Gopinagh.R

Reputation: 4916

The SQL Method

Why not concatenate all the 3 fields you need in the query you use itself like (Assuming you are with Postgres.), 

select (name || address|| to_char(age)) as data from my_table

In Ireport

As suggested, 

$F{Name} + "." + $F{Address} + "." + $F{Age}.toString()

too works if needed to make it work from the report.

Make sure that all your fields are of same data type.

Upvotes: 7

Anuj Patel
Anuj Patel

Reputation: 17859

If you want to put them in one line (which i guess is the case), its straight forward.

Put this as a text box $F{Name} + "." + $F{Address} + "." + $F{Age}.toString()

Or you can use string concatenation (I dont personally like the syntax, take more effort to understand) $F{Name}.concat(".").concat($F{Address}).concat(".").concat($F{Age})

Upvotes: 21

Related Questions