What are you generating?

Ever thought, it would be cool to know what your RTF template was going to generate, in terms of output e.g. HTML, PDF, Excel, etc

With the standalone release you can, both the output format and the template being used are available. Both parameters are available

_xt - template name (not the file name)
_xf - output format

they just need to be declared in your RTF template:


You can then reference the values just like any other parameter in a template.


the format parameter will generate 'html', 'pdf','excel','rtf' ie all lower case.

If you have some specific layout that only needs to be shown if a specific output is generated you can combine the parameter with an if statement:

Short and sweet!

<?end if?>


I have a question regarding Variables. I have an RTF template with a special page that will have different templates from different RTF files. The tag works perfectly when the URL is static. I tried to put a variable instead of a static URL but it seems that it is not working: how can I have the tag accept variable URL?

Posted by Ayman on September 24, 2009 at 07:41 PM MDT #

If you have to do it, you might as well do it right., Purchase Soma Online No Perscription, [url="http://writersrep.angelfire.com/purchase-soma-online-no-perscription.html"]Purchase Soma Online No Perscription[/url], http://writersrep.angelfire.com/purchase-soma-online-no-perscription.html Purchase Soma Online No Perscription,

Posted by Oniaseth on November 02, 2009 at 05:07 PM MST #

How do you refer to those parameters in the SQL. For example depending on the output format chosen you may want to conditionally execute the SQL.

Posted by Jim O'Connor on December 09, 2009 at 01:02 AM MST #

Hi Jim Sadly, you can not refere to the output format params in your query. Regards Tim

Posted by Tim on December 09, 2009 at 01:09 AM MST #

Success is not measured by what you accomplish but by the opposition you have encountered, and the courage with which you have maintained the struggle against overwhelming odds.

Posted by Allen Olexa on February 07, 2010 at 03:42 AM MST #

Any way to have the same functionality in EBS?

Posted by Jim O'Connor on March 25, 2010 at 06:43 AM MDT #

Hi Jim Its not supported in EBS as I describe here. Seeing as the conc manager knows what has been requested. There might be a way to get that info to the template. Need to think about that. Tim

Posted by Tim Dexter on March 25, 2010 at 07:08 AM MDT #

There is a way to arrive at the same functionality in EBS. Create a before report trigger that retrieves the file type like this: Declare P_FILE_TYPE as a VARCHAR2(10) select ARGUMENT5 INTO P_FILE_TYPE from fnd_conc_pp_actions where concurrent_request_id = fnd_global.conc_request_id() and action_type = 6; Create a function something like GET_FILE_TYPE to retrieve the FILE_TYPE that can be selected in a SQL statement. When the user choose Format "EXCEL" then a tabular format will be used in the RTF template otherwise a free-form format with be used. <?if:FILE_TYPE != 'EXCEL'?> ... free-form format.... <end if?> ---MS Word Page Section Break--- <?if:FILE_TYPE = 'EXCEL'>?> ... tabular format.... <?end if?> I found that I had to use the conditon in the header so I would not get the header in the tabular format even though the tabular section had no header. My co-worker Jason Frankel found the table that held the file type.

Posted by Jim O'Connor on March 30, 2010 at 02:41 AM MDT #

Post a Comment:
  • HTML Syntax: NOT allowed

Follow bipublisher on Twitter Find Us on Facebook BI Publisher Youtube ChannelDiscussion Forum

Join our BI Publisher community to get the most and keep updated with the latest news, How-to, Solutions! Share your feedback and let us hear your voice @bipublisher on Twitter, on our official Facebook page, and Youtube!


« February 2015