How to develop XML Reports?
You can integrate and use these XML Reports in Oracle EBS.
Step 1: Write Query in Report Builder.
Step 2: Generate
XML File.
Select File > Generete to >
XML. It will ask you to save this XML file.
Step 3: Create
a RTF File and Load XML File.
Open word and create new document with Rich Text
Format.
Add-Ins > Data > Load XML Data
Step 4: Formatting
XML Report.
If you want to insert all fields then follow this
navigation:
Add-Ins > Insert > All Fields.
If you want to insert a single field then follow
this navigation:
Add-Ins > Insert > Field.
Remove Spacing between lines.
After using basic word formatting:
Step 5: XML
Report Preview.
You can export your xml report in following formats
Excel, Rich Text Format (RTF), Power Point, PDF and HTML.
Sample Output in MS Excel:
Sample Output in MS Word:
