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:

&lt;?param@begin:P_SUBMISSION_ID?&gt;<!--ram@begin:P_SUBMISSION_I-->

 We can now reference the parameter in our report by the syntax:

&lt;?$P_SUBMISSION_ID?&gt;

Example:
Parameter reference

This will result in the following layout:
Parameter result

Related posts:

  1. XML-Publisher building a matrix report
  2. Trick for multiple and flexible parameter passing with MOD_PLSQL and Web PL/SQL toolkit
  3. Session on XML Publisher – The Successor to Oracle Reports?
  4. XML-Publisher 5.6.2, datasource and users
  5. Bursting Reports, an easier way to distribute parts of your report