Intersting doubt -try if u can help

[bhaskarvanam]

Dear All,

 

Suppose I have a parameter called quarterpara and monthpara.

I have report query 'select * from date_dimesion  $P!{wherepara}'.

For wherepara ,i have a expression like this-$P{quarterpara}.equals("")?"":"where quarter=$P{quarterpara}"

Explaination:

If my quarterpara is blank,I will have a report query as 'select * from date_dimesion  $P!{wherepara}'

Else  'select * from date_dimesion where quarter=$P{quarterpara}'

 

 

I am not able to achieve the desired result.

I guess this is not possible in jasper.Please prove me wrong.

[tmatyashovsky]

Hi,

 

Not sure if it will help, but why you are using $P!{wherepara} instead of $P{wherepara} ?

 

Best regards,

Taras Matyashovsky