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:
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.
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
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
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.
Post a Comment