Date format in url parameter

[wisoo123]

I have a report that receives a date parameter (defined as java.util.date). I call my report with "JASPERSERVER/.../flow.html?...&MY_DATE_PAR=01.01.2015". That date parameter in german format worked fine on my JasperServer 5.6 installation. Now I updated to 6.1, and I always get empty reports. After some research (checked request/response when calling report inside JasperServer web interface) I found out that I get valid reports when using date format "yyyy-MM-dd".

 

Now I checked the Jasper config files. In applicationContext.xml I found parameter "dateFormat" with value "repository.date.format". The "jasperserver_config_de.properties" sets the value for "repository.date.format" on "dd.MM.yyyy", so my date parameter should be valid?

 

How can I tell JasperServer 6.1.1 to accept german dates in urls?

 

Thanks

[Sukanya Parisa]

For this try to manage in drill report query, In the query pass the date after change the date format....like

your DateField=Cast(DateParameterValue from URL,'mm-dd-yyyy')

If u manage like this in ur drill report query , then what ever the date format from url, throught query automatically it will change.

[wisoo123]

Hi parisalakshmi,

casting the date inside my report according to your advice does work.

The problem is, that I have a lot of reports with date parameters, and I would have to change all these reports. That´s why I would prefer to modify the JasperServer config so it runs my reports like in previous versions ...