Home » Developer & Programmer » Reports & Discoverer » Add new field to an rtf (Oracle 11.5.10 ebusiness suite, Purchasing, Oracle reports XML publisher)
Add new field to an rtf [message #484563] Wed, 01 December 2010 10:57 Go to next message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
I am using Oracle 11.5.10 ebusiness suite.

I have modified a custom report (an rdf) that it now picks up field xx for the address rather than POH_SHIP_ADDRESS_LINE1..
I modified the template.rtf and uploaded it using the responsibility Oracle XML publisher.
However instead of getting the field value in the report. I get XX (i.e. the field name not the field value).

How can I ensure that the report picks up the value?
Re: Add new field to an rtf [message #484780 is a reply to message #484563] Thu, 02 December 2010 13:59 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
You need to provide little more details.
1. Previously you were using rdf?
2. Now you have changed that to rtf (XML Publisher)?
3. What is your xml output file is showing the data for that field?
4. What is the field you have introduced (Default Text)
and what is the value/tag your have given in Add Help Text in the form field?

By
Vamsi
Re: Add new field to an rtf [message #484861 is a reply to message #484780] Fri, 03 December 2010 05:47 Go to previous message
davholla
Messages: 116
Registered: August 2009
Location: London
Senior Member
Here are the answers to your questions and hopefully a clear explanation of the problem below.

Thanks a lot for your help.
1. Previously you were using rdf?
There is an .rdf field which is run - but the output is defined in an rtf
2. Now you have changed that to rtf (XML Publisher)?
The person who last modified the .rdf did that - whoever he or she is
3. What is your xml output file is showing the data for that field?
It is templatename.xml
4. What is the field you have introduced (Default Text)
and what is the value/tag your have given in Add Help Text in the form field?
Just a new address field.
Here is a


There is a customised report that I have been asked to change.
I added the new field new_field to the the .rdf and it runs fine but the field new_field does not appear..

I found that the output is defined not in the .rdf but in the template which I can modify via the .rtf which is stored
in XML Publisher -> Templates.

I downloaded the template.rtf. One problem :-
1) How do I create a new XML data source which has new_field plus so all the existing fields so that I can add it to the
other fields.
Previous Topic: Oracle Report 10g (2 Merged)
Next Topic: How to execute Query 2 if Query 1 doesnt reterive anything
Goto Forum:
  


Current Time: Tue Apr 23 16:21:40 CDT 2024