gaetan_prulhiere

Hello I would like to change the field in the select of my subreport's query.. For example, in the query : select max(field) from myTable, i would like to have a parameter $P{MAX_MIN} to choose the maximum or the minimum like that : select $P{MAX_MIN} from myTable where $P{MAX_MIN} = 'max(field)' or 'min(field)'. Can I do that or something like that ?

First, thanks for your answer. I could add a where condition in my query but if I do this, I couldn't display other country in my report. I could make a subreport too but i don't want to do that just for displaying one field. I can't add a filterExpression on a field, is not ? With the printwhenexpression, i try all evaluation time and none work

Hello I would like to display only one value of a list with an condition. For example, my table : COUNTRYPOPULATIONFRANCE100SPAIN80GERMANY110With my query in the report : (select * from table), i would like to do a list of country with the population in the detail zone and only show france's population in the page header. I try with the "Print when expression" : $F{COUNTRY} == "FRANCE", on the field $F{POPULATION} or to make a variable FRANCE_POP with expression ( $F{COUNTRY} == "FRANCE" ? $F{POPULATION} : "") But, my result is the last value and not the value of France. How i can stop the search when the good value is find or block the result to have the right value ? I don't know if my question understandable and i'm french. Thanks