Saturday, January 3, 2009

XML Publisher report

XML Publisher report

1)Develop the Report(.rdf) Only DataModel

2)Save the report and Compoile and Generate the data in .xml Format File=>Generate to File => XML

3)Open the Ms-WOrd document Design the Layout include the follwing Tool Bar options called Form and Templete builder
4)Define the Table and Specify the Titles and Labels whatever we would like to print

5)Include 'Text Form Field' Double CLick => Add Help Text button enter the following syntax : Here G_USER_ID is Group name from .rdf Data Model Note: It means Indirectley Repeating Frame starting

6)Define the Fields which we would like to display Include 'Text Form Field' Double CLick => Add Help Text button enter the following syntax ?
Note: Define all the fields like this

7)We have to close the Repeating Frame (For each Loop) Include 'Text Form Field' Double CLick => Add Help Text button enter the following syntax

8)Save the document in .rtf(Rich Text File format)

9)Load the .xml file data and generate the Output in pdf Format Data=>Load XMl Data=>Load the .xml File=>Once Data is Loaded succesfully

10)Generate the Preview as per this Preview=>PDF


Registering in Apps

1)Develop the .rdf file and .rtf file

2)Register both .rdf and .rtf file
.rdf File

registration

1)Move the .rdf file into CUS_TOP\11.5.0\Reports\US

2)Create Execuiteable

Concurrent Program Output = XML

Request Group

Responsibility

User

SRS

3)Copy the Concurrent Program Short name .rtf File

Regitration:

1)Goto the XML Publisher Administrator Responsibility

2)Select Data Definations form Enter Data Defination

Name = Enter Any Name

Code = Concurrent Program Short Name

Application = Any application

startdate = Current Date

3)Copy the DataDefination name we have to add this to the Templete

4)Open the Templete Form

Enter Templete Name : Any Name

DataDefination : enter data defination whatever we have created

Code : Concurrent Program Short Name

Type : rtf

application : any Application

File : Upload the .rtf file

Laguage : English

Territory : United States

5)Select Apply button

After register the .rtf file submit concurrent Program from SRS window system will automatically pick the .rtf file and generates the Output.
If we want to customze the .rtf file we have to download by using templete , Customize thenupload the .rtf templete

5 comments:

Somesh said...

Hello Sunil,

I have a questoin for you.
Suppose in my report i have an address whose values are fed from an XML. Example:

Location
AddressLine1
AddressLine2
City
Postal Code
Country

All the above values are fed from an XML. My question is, if no value is fed for say AddressLine2 from the XML, then currently a blank line is shown between Addressline1 and City (something like a gap). What should i do to remove this gap incase the XML has no value for it. YOur help would be most appreciated.

Thanks,
Somesh.

Contact: highbrow.admin@gmail.com said...

Hi Somesh,
You can use IF condition to avoid gaps between two lines.

in your case,
Start If condition at start of 'AddressLine2' and end if condition
start of 'City'.

It looks like this.

'IF'Location
'EF''IF'AddressLine1
'EF''IF'AddressLine2
'EF''IF'City
'EF''IF'Postal Code
'EF''IF'Country'EF'

http://oracle500.blogspot.com

Anonymous said...

Hi,
I tried to use if condition as given below however the line is not skipped and address line2 is displayed after address line1.

Pls help out me.




Thanks

Unknown said...
This comment has been removed by the author.
Unknown said...

Regards
Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, OAF, ADF, SQL, PL/SQL, D2K at sridevikoduru@oracleappstechnical.com | +91 - 9581017828.