Jaspersoft Server | encrypted data in database, how to get decrypted data in jasper reports

[shivani.katariya]

I had a datasources which has some encrypted fileds like name, email etc. I would like to handle or decrypted it in jasper server / may be at jasper studio jrxml file . how this can be achieved in jasper server ?

[marianol]

Hi, to decrypt the data coming from the DB you will need to do that at the Java Layer in the JRXML by using my custom class to process it.

You can achieve that using scriptlets or custom functions in Jaspersoft Studio check this link http://community.jaspersoft.com/wiki/jaspersoft-studio-expression-editor-how-extend-it-and-contribute-your-own-functions-part-2-0 

[shivani.katariya]

Thanxs marianol. It worked well