JasperReportsPlugIn Problem with Image from Datafield

Classic Servoy
1

I try to implement a Image directly from mySQL Database (Media-Field) in Jasper Reports.

However, various attempts brought no success.

I think this should possible … or not?
Is this a problm with my Software configuration?
Can anyone help

Installed Software:

Servoy 8.3.2
Jasper Studio 6.5.1
Barcode_Servoy_JasperReports_Plugin_v.6.4.1.7z.001
Barcode_Servoy_JasperReports_Plugin_v.6.4.1.7z.002

BR
Andreas

2

Hi Andreas

I use an Image Control and as an expression
$P{cMandLogo} != null ? net.sf.jasperreports.engine.util.JRImageLoader.loadImage((byte)$P{cMandLogo}) : null

cMandLogo is passed to the report engine as Parameter, which is nothing more as the content of a database field. Instead of $P{param} you should be able to use $F{Field}.

HTH
Fritz

3

here is an example that may help:

<?xml version="1.0" encoding="UTF-8"?>

<jasperReport xmlns=“http://jasperreports.sourceforge.net/jasperreports” xmlns:xsi=“http://www.w3.org/2001/XMLSchema-instance” xsi:schemaLocation=“http://jasperreports.sourceforge.net/jasperreports http://jasperreports.sourceforge.net/xs … report.xsd” name=“f_products” pageWidth=“595” pageHeight=“842” columnWidth=“555” leftMargin=“20” rightMargin=“20” topMargin=“20” bottomMargin=“20” uuid=“96b8fd89-386b-483b-9a1f-4df248f4f63f”>