I am bringing in an xml file into word to create a report. This is being done using a plugin from oracle called BI Publisher. I believe you do not need to be familiar with this to answer my question.
The field I am trying to display is a blob - Employee Photo. In Microsoft word's properties the text form field is a 'regular text with maximum length - unlimitted.
The image is being displayed in a column of a table. When the employee has no photo, huge blank spaces result. ie the table rows span many pages with no data.
The xml handling this field, employee photo, in the plug is :
t content-type=”image/jpg” height=”70 px” width=”55 px”><xsl:value-of select=”B.EMPLOYEE_PHOTO”/
So my questions are :
1. Should the Blob be interpreted as numeric or text? When I change the photo field to numeric, the report format is fine. However, you get the photo displaying with numbers and people without photo's are blank but do the table rows spanning many pages.
2. Can I wrap the xml statments to ignore displaying B.EMPLOYEE_PHOTO is blank and how would I do this?