[How change the subreport's query]

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 ?

[How display a value with condition]

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

[How display a value with condition]

Hello

I would like to display only one value of a list with an condition. For example, my table : 

COUNTRY	POPULATION
FRANCE	100
SPAIN	80
GERMANY	110

With 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