How add background image from Oracle database?

Hi. 

I have TIBCO Jaspersoft® Studio 6.8.0 and Oracle's JDBC driver version 7 to connect to Oracle database XE. 

I have a table that has a BLOB column in which an image is stored. The image is a PNG but I can convert it to other image formats if needed.

Here is the query that retrieves the image...

select rosheta_img from rosheta_design;

The query retrieves one row. 

I need to set the retrieved image as a background for my report. I need it to cover all the page(including margins).

What is the best way to do that?

P.S I do not mind updating JasperSoft Studio or OJDBC or else if that could ease the task. 

Thanks a lot.

Eyesmagicx's picture
Joined: Jun 24 2019 - 7:09am
Last seen: 9 months 1 week ago

2 Answers:

sanderse's picture
4518
Joined: Jul 31 2017 - 3:51pm
Last seen: 14 hours 16 min ago

Change the expression of the image field of the dataset to inputStream. Then create an image element then set it's expression to that field.

Eyesmagicx's picture
Joined: Jun 24 2019 - 7:09am
Last seen: 9 months 1 week ago
Feedback
randomness