Ad-hoc on domain. Change displayed date format

0

I am working with Ad-hoc views on domains in Jasper 7.1.

How can i change the default date format dor date displayed in the ad-hoc view?

Default format is Jan 1,2018. I would like to use 1/01/18

Alex42's picture
122
Joined: Dec 7 2016 - 4:24am
Last seen: 4 months 3 days ago

3 Answers:

0

You need to edit the adhoc_masks.properties file of your Jasper server.

riodavid's picture
507
Joined: Oct 27 2016 - 1:57am
Last seen: 1 year 2 weeks ago
0

I know, I have tried it and it use to work(6.3).

Please try it on anything older than 6.3 and let me know if it works(it will not). You can test in on TIBCO provided sample FoodMart/SuperMart data set/domains. There it doesn't work either.Not even changing to the existing predefined masks

Alex42's picture
122
Joined: Dec 7 2016 - 4:24am
Last seen: 4 months 3 days ago
0

You can set this in Adhoc Editor itself by right clicking on Date field, like this: http://prntscr.com/li80om

Also, you can do same thing on Domain level by editing field Data format in Display tab: http://prntscr.com/li81ge

prusyn's picture
644
Joined: Feb 22 2018 - 3:49am
Last seen: 2 days 14 min ago
Feedback
randomness