Adding an SVG image steam from a database to a report

Hello everyone, 
 
I am using BIRT 2.5.0 and I've got a software that uses it to auto-generate reports with informations located on a Oracle database. 
 
So, everything is working fine, but I need to get an SVG image from a database and display it on the report (with BIRT Report Viewer for example). So, I'm retrieving this, for example, from the database : 
 
<blockquote class='ipsBlockquote' ><svg xmlns="<a class='bbc_url' href='http://www.w3.org/2000/svg'>http://www.w3.org/2000/svg"</a> version="1.1" width="600" height="400"><title>signature</title><desc>2</desc><rect width="600" height="400" x="0" y="0" fill="#F1E9D5" /><path fill="none" stroke="black" stroke-width="3" d="M416.0,176.0 Q416.0,176.0 347.0,257.0 Q278.0,338.0 258.5,344.5 Q239.0,351.0 190.5,337.5 Q142.0,324.0 132.0,317.0 Q122.0,310.0 123.0,299.0 Q124.0,288.0 128.0,281.5 Q132.0,275.0 175.5,260.0 Q219.0,245.0 246.0,246.0 Q273.0,247.0 313.5,261.5 Q354.0,276.0 385.5,289.0 Q417.0,302.0 444.5,315.0 Q472.0,328.0 491.5,337.0 Q511.0,346.0 520.0,346.5 Q529.0,347.0 529.0,347.0" /></svg></blockquote>
 
Now, what can I do to display this xml-text as the drawn image in the final report ? 
 
As a text form, it just display the text. 
 
Thanks for your help ! 
 
Lynal

Find more posts tagged with

Comments

kclark

What is the data type of the image in you're DB? You could change it to blob and display the image that way. <a class='bbc_url' href='http://www.birt-exchange.org/org/devshare/designing-birt-reports/529-sample-birt-report-elements-example/'>This devshare</a> shows how to display a blob type as an image.

Clement Wong

Lynal, 
 
If the SVG data type in your Oracle DB is a character data type, you can use the Oracle built-in function, utl_raw.cast_to_raw, to convert from character to BLOB. 
 
In your Data Set's query, you can update the SQL to: 
<pre class='_prettyXprint _lang-auto _linenums:0'>SELECT utl_raw.cast_to_raw(your_SVG_db_column) AS mySVGBlob</pre>
Then, in the Image Control, select the "Dynamic Image" option and set the "dynamic image expression" to the new output column. 
<pre class='_prettyXprint _lang-auto _linenums:0'>row["mySVGBlob"]</pre>
You will now be able to view the SVG within your report from a (SVG supported) browser, or if exported to PDF.

Lynal

Thanks, klarck and Clement, I will try this tomorrow !

The datatype is VARCHAR2 but I can change into BLOB, or use the oracle function.

I'll tell you if it works, but thanks

Lynal

I tried this : 
 
<blockquote class='ipsBlockquote' >
In your Data Set's query, you can update the SQL to: 
 
SELECT utl_raw.cast_to_raw(your_SVG_db_column) AS mySVGBlob 
 
 
Then, in the Image Control, select the "Dynamic Image" option and set the "dynamic image expression" to the new output column. 
 
row["mySVGBlob"] 
 
 
You will now be able to view the SVG within your report from a (SVG supported) browser, or if exported to PDF.</blockquote>
 
The image isn't displayed. When I try to export the report as a PDF, I've got this error instead : 
 
<blockquote class='ipsBlockquote' >"Current report item is 
not supported in this 
report format."</blockquote>
 
Note, the result of the utl_raw.cast seems to return an hexadecimal string : 3C 73 76 67 20 78 6D 6C ... 
 
 
Any ideas ?

kclark

Are you exporting to PDF from Eclipse or running the webviewer then exporting to PDF?

Clement Wong

Sorry Lynal, 
 
Looking back at my reply, I forgot to add a final step: 
 
Update the Image control's property > Type Expression, and add "image/svg+xml" -- including the double quotes.

Lynal

Thanks Clement,

Unfortunately, it doesn't seem to work either. Instead of display the image, BIRT displays the hexa text :

3C 73 76 67 20 78 6D 6C ...

And a square with a point on the center.

I put the "image/svg+xml" in the "Type expression" property (Advanced options), is it there ?

I attached the screenshot and my report.rptdesign, if you could have a look, I would really appreciate.

Thanks anyway to help me !

Clement Wong

I was about to ask you what version of BIRT you were running, but I reread your original post and it's 2.5.0. 
 
The reason for asking the version is because I recently answered <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/28726-charts-in-firefox-18-0-1/page__view__findpost__p__113793'>this thread about SVGs not displaying</a>. My reply also applies to SVG images too. 
 
The sample report in my environment were tested in both BIRT 4.2.1 and commercial Actuate 3.7.2, and rendered correctly. 
 
When I tested with (OS) BIRT 3.7.2, since I don't have BIRT 2.5.0, I saw that the SVGs were not displaying for the same reason as explained in <a class='bbc_url' href='http://www.birt-exchange.org/org/forum/index.php/topic/28726-charts-in-firefox-18-0-1/page__view__findpost__p__113793'>the referenced thread</a>. 
 
Will any of those three options work for you?

Lynal

Oh, I thought I replied, sorry !

It's working ! It's just the BIRT viewer which does not display the SVG image, but it's working when I export the report in PDF.

So, I'd like to thank you both for your help