Jump to content
Changes to the Jaspersoft community edition download ×

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


senthilk

Recommended Posts

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?

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...