How change the subreport's query

[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 ?

[mbmorgan]

Hi, I previously posted an answer, but for some reason it is not showing.

It sounds like you want to implement a conditional query. Here is a link to a very helpful video explaining how to do just that:

http://community.jaspersoft.com/blog/how-implement-conditional-query-ireport-using-sample-database-sample-included

Good Luck,

M.B.Morgan