Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
How to display image in birt report?
codename_
I want to display my image saved on my mysql database to display in birt...I tried to drag the select statement in my query but image was not shown...how to do this?
Find more posts tagged with
Comments
kclark
How is the image stored in the DB? If it's a BLOB you can follow <a class='bbc_url' href='
http://www.birt-exchange.org/org/devshare/designing-birt-reports/529-sample-birt-report-elements-example/'>this
devshare</a> on how to display images stored as a BLOB in your db.
codename_
it is in longblob datatype...is not just normall dragging out the image field in the db ang place in birt report?
codename_
I cannot manage to bring out the image from my database. Can anyone help me steps by step?
codename_
Here's the steps I did
- add image property then set to Dynamic Image
- select image data
- In dataset radio button I select my dataset name
- I checked the checkbox for image field
- ok
- ok
When I run the preview results the image was not shown why?
Clement Wong
To troubleshoot this issue further...<br />
<br />
1. What BIRT version are you using?<br />
<br />
2. Does the s<a class='bbc_url' href='
http://www.birt-exchange.org/org/devshare/designing-birt-reports/529-sample-birt-report-elements-example/'>ample
report from the DevShare</a> Kristopher referenced work in your environment?<br />
<br />
3. What image type is stored in your BLOB?<br />
<br />
4. The steps you posted look correct. Let's verify your design:<br />
<br />
A. In your Data Set's Output Columns, for your BLOB column is in your report, what Type does it show? It should be Blob.<br />
B. If you click on "Select Image Data..." in your image control, the column for your BLOB is checked and the Data Type is "Blob"?<br />
5. Just to make sure you have valid BLOB data that can be displayed as an image, can you see the image in any of your MySQL client tools? I use the <a class='bbc_url' href='
http://www.heidisql.com/'>lightweight
(free) HeidiSQL</a> and it can <a class='bbc_url' href='
http://www.heidisql.com/screenshots.php?which=imagepreview'>display
BLOB as images for most formats</a>.
