Parameter to subreport

[mnf59]

Hi all, i'm very new to jasper report and Ireport too, i need to solve a problem. I'm working on a subreport that has to execute a query with a between condition and the min and max values should come from a query in the master report. I've followed the help so i've created parameters in the subreport definition with name MIN1 MAX1 and default value $F{MIN1} and $F{MAX1},

then in the subreport query i've inserted

 

where CCF_ID between to_number (${LMIN1}) and to_number(${LMAX1})

 

and created 2 new parameters.But i've an error about Token sql92 not supported when i try to save the query.

Without the where condition the report works fine.

Where is my error ?

Thanks.

[mnf59]

Well, i've solved my problem.

[veerchinta]

hi, can you tell me which function or how did u get the maximum value of that database column?

[Java_Jasper]

Tell how, it helps others