Issue in generating conditional query with Date field parameter

[deepapriyan]

  Hi

I have created a report which take From Date as an input Control Value.While declaring the dataType for this field gave the type as "Date".In my jrxml I have created a parameter $P{FromDate} as follows

<parameter name="FromDate" class="java.util.Date"/>

This field is not a mandatory field and can be left blank.If the user enters some value,based on that Date value I need to filter out my data and show in the report.So I am creating a conditional query statement to be added to my basic query.

My problem is I am not able to check for the condition in the query whether $P{FromDate} is null or empty or have a value and form my query.Please help.This is urgent.

 

Thanks In Advance

Deepa

[chicuslavic]

Hi

try $X{GREATER, TABLE_COL, FromDate}

best regards,

Veaceslav Chicu