0 
0 This week I have played a bit with XML-Publisher. The goal was take some reports and try to migrate them to XML-Publisher version. Yesterday I posted a blog about how you can setup a matrix report using the proper tags and references. I must say I was very content that it was possible and although it took me some time. After I accomplished the matrix layout the next question came up. How can I display the input parameters of the report in my report?
It is a very small trick you should understand. first you have to create a declaration and reference to your parameter in your report. Let us asume that my report accepts as input the parameter P_SUBMISSION_ID.
You create a tag in your RTF file with the following syntax:
<?param@begin:P_SUBMISSION_ID?>
We can now reference the parameter in our report by the syntax:
<?$P_SUBMISSION_ID?>
Example:
This will result in the following layout:
Related posts:
Collaborate 08 – Day 4 – The Final Day E-Business Suite 11i Certified on OEL5, RHEL5 and SLES10 
Oracle E-Business Suite R12 with OEM10G 
Presenting at OOW: Mixing E-Business & Pleasure – integration scenarios for Oracle E- Business Suite and SOA Suite Oracle Workflow, a brief introduction – Part 2 Building a simple workflow
Thanks for the tip sister. I was having quite a lot of trouble displaying my input parameters since I am new to XML Publisher. This is gonna help me out a lot.
Regina from New BMW
Hai friends
I am new to xml publisher.The article on ‘How to display input parameters is good’.I have a query on this.For my report,there are two input parameters (for dates).I am using FND_STANDARD_DATE value set for dates.Now I have to display these dates in the report.
The problem is that FND_STANDARD_DATE converts the date that user enters into YYYY/MM/DD HH24:MI:SS format and the same is printed in the report.I am using to_char( to convert into DD-MON-YYYY format but it’s not working.How can i achieve this?
Hello >>
I’m new to XML-Publisher and i’m using Microsoft word for template creating.
I’m facing some difficulties in creating a master-detail report…
how can I accomplish that.. should I write one data model query that include everything or should I seperate them ???
any help