Build Query Dinamically

[ardn0001]

Hi want build my main query dinamically of course using parameters, the only requeriment that we need is receive SQL operator throught a Paramater or a Function, how can I do this, is a designer issue or JasperReports problem?

[slow]

you can use the syntax $P!{parameter_name}

with $P!{} you can pass values that aren't treated as values to be transfered to a prepared statement, but it represents little "sql-piece" of the query you use...

so you can create a very dinamic query passing the correct sql code.

 

_________________________________________

if it works... give me KARMA points please!    : ) 
_________________________________________

listening: Jesus And Mary Chain - Snakedriver