Join the OracleApps88 Telegram group @OracleApps88to get more information on Oracle EBS R12/Oracle Fusion applications.

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.

Sunday, May 29, 2016

XML Publisher Commands

Seq
Feature
Command
1
Choose
<?choose:?><?when:ABSENCE_DAYS=1?> 
(Any logo for EX)
<?end when?><?when:ABSENCE_DAYS=2?>
(Any Word for EX)    2 Days   
<?end when?><?end choose?>



2
If (Change field color)
<?ABSENCE_DAYS?><?if:ABSENCE_DAYS=1?>  <xsl:attribute  xdofo:ctx="block" name="background-color">red  </xsl:attribute>  <?end if?>

If (Change Record but this code in Key)
<?if@row:ABSENCE_DAYS=1?><xsl:attribute xdofo:ctx="incontext" name="background-color">green</xsl:attribute><?end if?>

If-Then-Else
<?xdofx:if ABSENCE_DAYS = 1 then 'x' else 'VV'end if?>



3
Column Format
<?if@column:ORGANIZATION_NAME="Access Network Development"?>
Column Name
<?end if?>
4
Variable (set & get)
<?xdoxslt:set_variable($_XDOCTX, 'x', 1)?>  <?xdoxslt:get_variable($_XDOCTX, 'x')?>

Add 10 to Variable x (code in Key)
<?xdoxslt:set_variable($_XDOCTX, 'x', xdoxslt:get_variable($_XDOCTX, 'x')+10)?><?xdoxslt:get_variable($_XDOCTX, 'x')?>  



5
Page break
<?split-by-page-break:?>



6
Header & Footer
Header
<?start:body?>
                         Report Body
<?end body?>
Footer



In header <?call:customheader?>
In footer <?call:customfooter?>
In bage body
<?template: customheader?>
Here our header
<?end template ?>
<?template: customfooter?>
Here our footer
<?end template?>
Report Body



7
Page Total
<?ABSENCE_DAYS?><?add-page-total:XXCPX;'ABSENCE_DAYS'?>  (of calculated field)


In the footer to appear in every page
Sub Total Absence Days per page : <?show-page-total:XXCPX;'#,##0.00'?>




8
Run accumulative Total for column
Before the table define variable in the Key

<?xdoxslt:set_variable($_XDOCTX, 'RTotVar', 0)?>

Delete table End code and create new column the set in the Key

<?xdoxslt:set_variable($_XDOCTX, 'RTotVar', xdoxslt:get_variable($_XDOCTX, 'RTotVar') + ABSENCE_DAYS)?><?xdoxslt:get_variable($_XDOCTX, 'RTotVar')?>




9
Forward & Carry Forward
Before the table
<?init-page-total: EntAmt?>

In the table
<?ABSENCE_DAYS?><?add-page-total:EntAmt;ABSENCE_DAYS?>

After the table
<?end-page-total:EntAmt?>

In the Header in the Key code
<xdofo:inline-total display-condition="exceptfirst" name="EntAmt">Brought Forward: <xdofo:show-brought-forward name="EntAmt" format="99G999G999D00"/></xdofo:inline-total>

In the Footer
1-      Get page total
<?show-page-total:EntAmt;"99G999G999D00"?>

2-      Get Carried forward in the Key code
<xdofo:inline-total display-condition="exceptlast" name="EntAmt">Carried Forward:   <xdofo:show-carry-forward name="EntAmt" format="99G999G999D00"/></xdofo:inline-total>


No comments:

Post a Comment

If you are facing any issues while copying the Code/Script or any issues with Posts, Please send a mail to OracleApp88@Yahoo.com or message me at @apps88 or +91 905 957 4321 in telegram.
Best Blogger TipsGet Flower Effect