mattreport Posted September 10, 2014 Share Posted September 10, 2014 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. Link to comment Share on other sites More sharing options...
mlopez_1 Posted September 10, 2014 Share Posted September 10, 2014 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 Link to comment Share on other sites More sharing options...
mattreport Posted September 10, 2014 Author Share Posted September 10, 2014 Its already in its own band, What query do i need to use to achieve this Link to comment Share on other sites More sharing options...
mlopez_1 Posted September 10, 2014 Share Posted September 10, 2014 Using FIRST statement in SQL. This not a JasperServer problem. Link to comment Share on other sites More sharing options...
mattreport Posted September 10, 2014 Author Share Posted September 10, 2014 Im not using SQL in this Link to comment Share on other sites More sharing options...
mlopez_1 Posted September 10, 2014 Share Posted September 10, 2014 Use equivalent statements in your query language Link to comment Share on other sites More sharing options...
mattreport Posted September 10, 2014 Author Share Posted September 10, 2014 Yeh thats what im hoping someone can tell me as i dont know the equivalent statements when using $F{Field} etc Link to comment Share on other sites More sharing options...
AnnMary.Thomas Posted September 12, 2014 Share Posted September 12, 2014 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 Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now