Not able to see sql server domain calculated fields in Jasper studio

1

Hi

I have created julian date to normal date using microsoft sql server domain calculated fields in Jasper report server and it's working fine in Jasper report server. Please find below calculated field code.

"CASE WHEN (" + sqlArgs[0] + " > 0 and " + sqlArgs[0] + " is not null) then convert(Date,DATEADD(dd, (" + sqlArgs[0] + " % 1000) - 1, DATEADD(yy, " + sqlArgs[0] + " / 1000, 0)),120) else null end"

when I tried to retrieve in Jasper studio it's coming null value not date . How do I get the conversion calculated date value from jasper server to jasper studio?

senthilk's picture
Joined: Feb 27 2018 - 10:38pm
Last seen: 10 months 1 day ago

0 Answers:

No answers yet
Feedback
randomness