Adding Picture in Report PeopleSoft Bi-Publisher

To add a picture in Bi-Publisher Report is Quite Easy.

Just Follow the Following Steps.

1. Get the Photo you want to display from PS_EMPL_PHOTO table, and check that is should not be null.
It requires to be match by any emplid in PeopleSoft, I am using PS_ACAD_PROG table just to get emplid from that table. You may join it from any other table.

PS_EMPL_PHOTO contains the EMPLID and Photo as a Blob File, you have to convert it into Base64Encode to view it on Bi-Publisher.

make aView in Application Designer.



Photo Field Should be type Long Character and Maximum Length 32000



Select
NVL ((SELECT base64encode (p.employee_photo) FROM PS_EMPL_PHOTO p WHERE p.emplid =A.Emplid),'Photo') ,
A.emplid,
from PS_ACAD_PROG A

 Now add the View in Security Tree and make a query of that view having prompt on Emplid.




Now add Data Source of That Query.




Now Make a report Definition and download schema of that query.


Now Load that Schema in Microsoft Word







Now Insert field of Photo in Microsoft word.







Now double click on field and open Bi-Publisher Properties and add this code.



<fo:instream-foreign-object content-type="image/jpg" height="120 px" width="90 px" xdofo:alt="An Image" ><xsl:value-of select=".//IOBMM_APP_PHOTO"/></fo:instream-foreign-object>




And Save it as RTF format.

Now upload that schema in Report Definition.



and select output format as PDF.

Now search that report in Report Query Viewer.



click on view report and insert ID.




The Photo will be visible on PDF report.




Thank You :)