Postgres bytea columns in Jasper

Classic Servoy
1

Hi Guys,
I’m sure there are others with this issue.
I am trying to pass a postgres bytea column containing a logo to a Jasper report as a parameter. And having trouble :-(… I have searched the internet and there are lots of different solutions to the problem, some quite complex. But I’m wondering what is the best way using Servoy, I believe there’s a need to convert the image column before sending it to Jasper, maybe… ?
From my testing if I use SQL in Jasper directly, the image displays fine by simply setting the field class to java.io.InputStream, but as I’m using Servoy foundsets this is not very practical. Any help here would be wonderful

Sent from my ASUS_Z01KD using Tapatalk

2

Found the Problem posting here for others…

/** @type {java.io.InputStream} */
Var _image = mymediacolumn
_logo = new Packages.java.io.ByteArrayInputStream(_image);

var _params = {RPT_LOGO:_logo}

Just make sure RPT_LOGO is you jasper parameter name and set the class for your parameter in jasper to “java.io.InputStream”