$F{FIELD} Jaspersoft iReport Return one value only
Posted on September 10, 2014 at 2:12am
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.
Joined: Sep 10 2014 - 1:58am
Last seen: 8 years 10 months ago
Posted on September 10, 2014 at 3:41am
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.
Regards
Joined: Oct 21 2013 - 8:08am
Last seen: 14 hours 11 min ago
Posted on September 12, 2014 at 5:16am
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
Joined: Jun 18 2014 - 4:41am
Last seen: 2 years 1 month ago
Its already in its own band,
What query do i need to use to achieve this
Using FIRST statement in SQL. This not a JasperServer problem.
Im not using SQL in this
Use equivalent statements in your query language
Yeh thats what im hoping someone can tell me as i dont know the equivalent statements when using $F{Field} etc