BI Publisher and Word 2007 issue
Hello,
I am running into some problems with the bi publisher, DataTemplates and rtf files.
First thing i did was to create a DataTemplate xml file with the following structure:
<dataTemplate name="ABPROPERS" description="GetABPersonsFromId" version="1.0">
<parameters>
<parameter name="P_PERSON_ID" dataType="number" defaultValue="242" />
</parameters>
<dataQuery>
<sqlStatement name="Q1">
<![CDATA[ Select pers.first_name first_name, pers.last_name last_name, user_status, start_date , end_date, business_group_id, assignment_id
From....
Where person_id = :P_PERSON_ID Order By start_date Desc]]>
</sqlStatement>
</dataQuery>
<dataStructure>
<group name="PERSON_INFORMATION" source="Q1">
<element name="first_name" value="last_name"/>
0