Jump to content
Changes to the Jaspersoft community edition download ×

How to show blob object image using ireport tool from sqlite database?


Recommended Posts

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

<!-- Created with Jaspersoft Studio version 6.3.1.final using JasperReports Library version 6.3.1  -->

<!-- 2017-02-18T16:30:23 -->

<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/xsd/jasperreport.xsd" name="Blank_A4_2" pageWidth="595" pageHeight="842" columnWidth="555" leftMargin="20" rightMargin="20" topMargin="20" bottomMargin="20" uuid="6bf1e8fc-5bd2-495a-abca-8c4d501c73af">

<property name="com.jaspersoft.studio.data.defaultdataadapter" value="sqlite"/>

<property name="com.jaspersoft.studio.data.sql.tables" value=""/>


<![CDATA[sELECT image

 FROM myimage




<field name="image" class="java.io.InputStream"/>


<band splitType="Stretch"/>



<band height="79" splitType="Stretch"/>



<band height="35" splitType="Stretch"/>



<band height="61" splitType="Stretch"/>



<band height="125" splitType="Stretch">


<reportElement x="130" y="20" width="310" height="88" uuid="8b07de5d-ac9e-4245-9ca1-ccd6fd3fe993"/>






<band height="45" splitType="Stretch"/>



<band height="54" splitType="Stretch"/>



<band height="42" splitType="Stretch"/>




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...