$F{FIELD} Jaspersoft iReport Return one value only

When using $F{FIELD} in Jaspersoft iReport, i want to return one value only (the first value).

Whether this is used in the 'Print when expression' or in the 'Text field expression' i don't know.

mattreport's picture
Joined: Sep 10 2014 - 1:58am
Last seen: 8 years 10 months ago

2 Answers:

Create a group for this field, and add a Band where you can put this value.


If you want the first of all records you must do in the query.



mlopez_1's picture
Joined: Oct 21 2013 - 8:08am
Last seen: 14 hours 11 min ago

Its already in its own band,

What query do i need to use to achieve this

mattreport - 9 years 2 weeks ago

Using FIRST statement in SQL. This not a JasperServer problem.

mlopez_1 - 9 years 2 weeks ago

Im not using SQL in this

mattreport - 9 years 2 weeks ago
show 2 more...

Use equivalent statements in your query language

mlopez_1 - 9 years 2 weeks ago

Yeh thats what im hoping someone can tell me as i dont know the equivalent statements when using $F{Field} etc

mattreport - 9 years 2 weeks ago

Create a variable which will increment for every record and set the initial value to 0. Use this variable for Prinnt When Expression preoperty ${V} <=1 in your field

AnnMary.Thomas's picture
Joined: Jun 18 2014 - 4:41am
Last seen: 2 years 1 month ago