How to create report without .rdf report builder?
Using Data template
How to write a loop in rtf template design?
<?for-each:group_column_name?>
Here is layout column
<?end for each?>
What are the XML publisher backend tables?
PER_GB_XDO_TEMPLATES
XDO_DS_DEFINITIONS_B
XDO_DS_DEFINITIONS_TL
XDO_DS_DEFINITIONS_VL
XDO_LOBS
XDO_TEMPLATES_B
XDO_TEMPLATES_TL
XDO_TEMPLATES_VL
XDO_TEMPLATE_FIELDS
XDO_TRANS_UNITS
XDO_TRANS_UNIT_PROPS
XDO_TRANS_UNIT_VALUES
How to design sub templates in rtf layout?
using following tags..
<?template:template_name?>
This is Last Page
<?end template?>
How to call a header or footer?
using the following header and footer tags
<?call:header?>
<?call:footer?>
Just use the tags on header and footer section of the page.
How to break the page in specific condition?
Use the following tag <?split-by-page-break:?>
How to use section break ?
<?for-each@section:G_CUSTOMER(This is group name)?>
How to create multi layouts in XMLP?
using below conditions
<?choose:?>
<?when:CF_CHOICE=’VENDOR’?>
Your template….
<?end when?>
<?when:CF_CHOICE=’INVOICE’?>
Your template….
<?end when?>
<?when:CF_CHOICE=’RECEIPT’?>
Your template….
<?end when?>
<?end choose?>
How to calculate the running total in XMLP?
<?xdoxslt:set_variable($_XDOCTX, ‘RTotVar’, xdoxslt:get_variable($_XDOCTX, ‘RTotVar’) + ACCTD_AMT(This is column name))?><?xdoxslt:get_variable($_XDOCTX, ‘RTotVar’)?>
How to submit a layout in the backend?
Use the below code write a procedure
fnd_request.add_layout
(template_appl_name => ‘application name’,
template_code => ‘your template code’,
template_language => ‘En’,
template_territory => ‘US’,
output_format => ‘PDF’
);
How to display the images in XMLP?
url:{‘http://image location’}
For example, enter:
url:{‘http://www.oracle.com/images/ora_log.gif’}
url:{‘${OA_MEDIA}/image name’}
How to pass the page numbers in rtf layout?
<REPORT>
<PAGESTART>200<\PAGESTART>
….
</REPORT>
Enter the following in your template:
<?initial-page-number:PAGESTART?>
How to display last page is differently in XML Publisher Reports?
what you want to display the test anything write in last of page
last page header
<?start@last-page-first:body?> <?end body?>
