This content has been marked as final. Show 12 replies
You can have a different header on the first page so assuming your layout fits you could include the stuff you want only on the first page in the first page header and have a different header for the second and subsequent pages.
Not sure about your other issue. What is your source for the XML? Are you still using the Oracle Report or have you converted to data Template also?
1. do you have Reporting Level and Reporting Context in XML ?
2. do you have Reporting Level and Reporting Context in RTF ?
3. are you not able to see the page number in output?
do you have the field in RTF ?
open rtf , use the microsoft page numbering, you dont need to do anything else,
page number will be displayed.
4. which field you want to display in first page ?
you want that to be displayed in header or footer ?
you can differentiate page first & others in those regions only.
When I converted the RDF to XML it created a Data Template and I uploaded that
template to the XML Publisher. ALso uploaded the RTF Template.
Then I run the concurrent request of that report which output is set to XML.
When RTFTemplateGenerator API created the RTF Template it had all the fields in the Body of the page not in the Header.
I want to move the part of the body to the Header. How do i do it? I want to print the part of the body only on the first page
This is my XML data I get
In my XML file I have this
<C_ORG_FROM_TABLES> hr_organization_information oi, hr_all_organization_units_tl le, hr_all_organization_units_tl ou </C_ORG_FROM_TABLES>
<C_MULTI_ORG_WHERE> AND atb.org_id = oi.organization_id
AND oi.org_information_context = 'Operating Unit Information'
AND DECODE(LTRIM(oi.org_information3,'0123456789'), NULL
, NULL ) = 4
AND DECODE(LTRIM(oi.org_information2,'0123456789'), NULL
, NULL ) = le.organization_id
AND ou.organization_id = oi.organization_id
AND ou.language = USERENV('LANG')
AND le.language = USERENV('LANG') </C_MULTI_ORG_WHERE>
As you are using the original report to generate the XML you do no need the data Template. You need to add the reporting level and context to the XML which you can do by creating a placeholder column for each and setting them to those two values. The placeholders will, by default, be included in the XML.
You need to open the rtf template in MS Word and move the relevant portion of the body into your header. Then go into the page layout and in the layout tab check the different first page option under headers and footers.
Yes modify the original RDF with the new placeholders.
Form fields are not allowed in the header so you have to key the raw element codes (e.g. <?ELEMENT_NAME?>)
Regarding your problem with the header not displaying properly, I have never seen that problem and have used headers on most of my templates. What version are you using. Assuming EBS you should get onto v5.6.3.
In my experience they are included in the XML by default but in the placeholder properties there is an option to "include in XML" so it might be that that option is set to no.
The other option is that the placeholders are NULL in which case the tags will not be included in the XML. Try adding some debugging in the report to determine exactly what the placeholder columns are being set to.