BLOB image in repeating groups

Rubelpasha

Summary

BLOB image in repeating groups

Content

I am trying to generate a table report for all the employee with their photo. I am using rtf template. The query is like below-

 

 

select

EMP_ID EMP_ID,

EMP_NAME EMP_NAME

xxgetbase64(EMP_PHOTO) PHOTO,

from hr_emp_mstr;

 

in PHOTO field i use code

<fo:instream-foreign-object content-type="image/jpg" height="1.5 in" width="1.2 in" >

<xsl:value-of select=".//PHOTO"/>

</fo:instream-foreign-object>

 

The above scenerio works fine If I generate the report for a single employee.

But If I want to generate for all employee then blank report is coming.

Dir_Pal

Check this this might help you

Kavitha_CP-Oracle

Hi,

Please review below

How to Insert Images and BLOBs Dynamically into Word Template or Document? (Doc ID 443957.1)

How To Insert Images and Logo in the XML Publisher Reports and Documents? (Doc ID 550627.1)