Has anyone successfully displayed an image from the PSCONTENT table into a BI Publisher report defin
People CS 9.2
Tools 8.54.33
Sql Server 12.0.5
Added image field type to query and converted to base 64 encode with this statement:
SELECT CAST('' AS xml).value( 'xs:base64Binary(sql:column("PSCONTENT.CONTDATA"))' , 'varchar(max)' ) FROM PSCONTENT WHERE CONTNAME = 'my_image') AS my_image_converted
Generated my xml file and loaded to RTF document
Dropped my image field on RTF document and change property to
<fo:instream-foreign-object content-type="image/jpg">
<xsl:value-of select="my_image_converted"/>
</fo:instream-foreign-object>
Uploaded RTF document to report definition
Executed report definition thru a push button
Report PDF output is generated but the image is not displayed