UK Format date in an ad hoc chart

[dave.hambleton]

I have created an ad hoc chart in JasperReports Server 6.0.1 with a timestamp as the row value. When I change the grouping to Minute by Day the date element shows in the US format MM/DD/YY, however I need to display this in the UK format DD/MM/YYYY. How can I achieve this?

[elizam]

You can change it for the whole server by setting a date format mask in the jasperserver_config.properties file.  (Really, there should be a UK locale option, but there doesn't seem to be.)

See the info on dates & data format masks on this page:

http://community.jaspersoft.com/documentation/tibco-jasperreports-server-administration-guide/v610/creating-locale

[dave.hambleton]

Thanks for the response.

I have made the changes as mentioned in the page link and my jasperserver_config.properties file has the following entries, 

date.format=dd-MM-yyyy

datetime.format=dd-MM-yyyy HH:mm:ss

calendar.date.format=dd-mm-yy

calendar.datetime.format=dd-mm-yy HH:mm:ss

 

I have restarted the server and this has made no impact to the row grouping format in the chart. The values are still showing as MM/DD/YY. 

 

This page http://community.jaspersoft.com/wiki/custom-grouping-ad-hoc-crosstabs seems to be in the right direction, however I can't understand where I need to make the necessary changes.

 

[dave.hambleton]

Does anybody else have any ides or suggestions?