Monday, 26 February 2018

L GENERATION STEPS FOR EXISTING oracle .rdf with oracle reports developer


 

XML GENERATION STEPS FOR EXISTING oracle .rdf reports (Which are not having xml)

Query the existing oracle reports  in system administrator Responsibility.

Concurrent è Program  è Defineè Press F11è Query the Report  


Concurrent è Program  è Defineè Press F11è Query the Report è Change the Out Put Format To XML. And save it.


 Run the report to generate XML. After Completion  of report go to from SRS window  Click On Diagnostics è View XML (For gathering the XML)



 

Save the XML with extension *.xml. (Use this  XML for creating RTF in BI Publisher )


 

 

Open M.S. Word Application for creating RTF In BI Publisher  Add-Ins  Tool


From the Data Men, Load the Xml Data which is saved on specific Location by existing Oracle Report created by you.

 

It will shows  that the data loaded successfully like following image.


 

Click on Insert menu èField Select appropriate one like following



Finally design the rtf as per your requirement and designing skil.


 

 

First create Data Definition in XML Publisher Administration Responsibility.

 Give the name of data definition sets(as per requirement)

Give the Code (it must be the same as Executable name of report )

Give the Application name as per

Give the Description if necessary

.

Second create the template in xml publisher administrator responsibility

Name as per your requirement

Code should match with data definition code

Application as per report

Data Definition – As u created in 1st step.

Type – RTF

Default Out Put type == Excel, rtf.pdf.html (as per your requirement)

Description – If anything necessary as per your requirement.

Template File  - Attach the RTF created in BI Publisheer.

Select the Language       - English           

Territory – Your country

Translatable – Enable