Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BLOB image in repeating groups

Received Response
34
Views
2
Comments

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.

Answers