How to print latest date (Jasper Reports with XML datasource) ??

[yulia.sebrovskaya]

 

I am a newbie to Jasper reports (version 4.5.1). I need help with my XMLdatasource.

This is my XML:

           

                        10.01.2013

                        11.02.2013

13.04.2013

                        12.03.2013

 

I need to print only latest date (date>13.04.2013)

Please help. Thanks.

[yulia.sebrovskaya]

Sorry. my xml:

[sanbez]

The simplest solution. Set order in iReport by date descending. And set PrintWhenExpression: $V{REPORT_COUNT} == 1  on this field (field must by type java.util.Date for expamle. Not String!)

But "simplest" != "best" :)

[yulia.sebrovskaya]

thanks.

But I do not know what will be the structure in xml(((

If I set PrintWhenExpression: $V{REPORT_COUNT} == 1, I see the first date ( 10.01.2013) but I need to print only latest date (13.04.2013)  

[sanbez]

Are you set in iReport order by descending? In this case lastest dete will be first.

[augarte]

Hi yulia, 

You can do the following. 

1) Retrieve the date as a field (String type). From now on, the name of this field will be 'date'.

2) Create a variable (the name could be 'vardate') with the following (java.util.Date type) with the following variable expression: new SimpleDateFormat ("dd.MM.yyyy").parse($F{date})

3) Create another variable (java.util.Date type) with Calculation=Highest and Variable Expression=${vardate}, being vardate the variable created in the previous step. 

This way you'll have the latest date.

Hope this helps.

Regards,

Aitor

 

[tusar.ranjan.pradhan]

i think you use this query, your problem might be solve.

 

select max(dat)

from

(

select to_date('26/08/2008','dd/mm/yyyy') as dat from dual

union all

select to_date('26/08/2010','dd/mm/yyyy') as dat from dual

union all

select to_date('26/03/2013','dd/mm/yyyy') as dat from dual

union all

select to_date('26/02/2013','dd/mm/yyyy') as dat from dual

union all

select to_date('26/01/2013','dd/mm/yyyy') as dat from dual

) tmp

[tusar.ranjan.pradhan]

select max(dat)

from

(

select to_date('26/08/2008','dd/mm/yyyy') as dat from dual

union all

select to_date('26/08/2010','dd/mm/yyyy') as dat from dual

union all

select to_date('26/03/2013','dd/mm/yyyy') as dat from dual

union all

select to_date('26/02/2013','dd/mm/yyyy') as dat from dual

union all

select to_date('26/01/2013','dd/mm/yyyy') as dat from dual

) tmp