nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Displaying WSQ Image on BIRT Reports

chrisandy

I tried generating a report from the browser, but some reason, the WSQ image (from the database) in it is not displayed.
 
Is there any thing i can do i make this image display on the report?

Find more posts tagged with

Comments

Clement Wong

From what I understand, WSQ is not a standard image format that can be displayed by a web browser and needs to be converted to an image format (such as PNG or JPG) that a web browser can display.
 
There is a Java library @ <a data-ipb='nomediaparse' href='https://github.com/kareez/jnbis'>https://github.com/kareez/jnbis</a>that can convert to those image formats and even to byte array. All you would need to do now is add the conversion into a new computed column, or convert it directly in the same column in the onFetch event of your data set.

chrisandy

Thanks Mr Wong,
 
I got the jar for the jnbis and dropped it in the lib folder in the WEB-INF.
 
I'm having challenges writing the script in 'on Render' (Scripting has been my weakness).
 
Tried using this script:
 
 InputStream pngStream = Jnbis.wsq() 
 .decode(row["WSQ_DATA"]) 
 .toPng() 
 .asByteArray();
 
Please advice

Clement Wong

TL;DR: Attached is a sample with a WSQ in a BIRT report. I only thing I could not test was the WSQ coming back from a database, but your code with .decode(row["WSQ_DATA"]) should work. 
Here's the approach I took: 
1. Downloaded JNBIS 2.0 from Maven @ <a data-ipb='nomediaparse' href='http://search.maven.org/remotecontent?filepath=com/github/mhshams/jnbis/2.0.0/jnbis-2.0.0.jar'>http://search.maven.org/remotecontent?filepath=com/github/mhshams/jnbis/2.0.0/jnbis-2.0.0.jar</a> 
2. Downloaded a sample WSQ image @ <a data-ipb='nomediaparse' href='http://www.cognaxon.com/index.php?page=download_wsqlibrary'>http://www.cognaxon.com/index.php?page=download_wsqlibrary</a>and saved to C:\temp 
3. In commercial iHub 3.1 BIRT Designer (but can be in OS BIRT too), created an empty report to make sure I could call JNBIS from BIRT 
 A. Moved the jnbbis-2.0.0.jar to my project root folder 
 B. Added the JAR as a Resource 
 C. In beforeFactory: 
 
<pre class="_prettyXprint">
importPackage(Packages.org.jnbis.api);
png = new Jnbis.wsq().decode("C:\\temp\\sample_image.wsq").toPng().asFile("C:\\temp\\sample_image.png");
</pre>
 The report ran and the PNG was created in my C:\temp. I opened the PNG file and saw a fingerprint image. 
 
 
4. Modified the report and commented out the beforeFactory code.
 
5. Created a Data Source (using sample Classic Models)
 
6. Created a Data Set (SELECT CUSTOMERNAME FROM CUSTOMERS) and set the fetch limit to 1 (for testing).
 A. Created a new Computed Column "WSQ Converted Image"
 i. Set Blob as data type
 ii. Set Expression as
<pre class="_prettyXprint">
importPackage(Packages.org.jnbis.api);
new Jnbis.wsq().decode("C:\\temp\\sample_image.wsq").toPng().asByteArray();</pre>
7. Added an Image Report Item into the Layout
 A. Set the "Select Image from:" to "Dynamic Image"
 B. Pressed the "Select Image Data..." button
 C. Selected the Customers Data Set
 D. Checked the "WSQ Converted Image" column
 
8. Ran the report and viola!