<?for-each:G_1?>
<?end for-each?> Page Break: <?split-by-page-break:?> Serial Number : <xsl:value-of select="position()"/> Summation column : <?sum(current-group()/LINE_AMT)?><?end body?>
<?xdofx:decode(C_AMT_DUE_REM_INV,0,'',C_AMT_DUE_REM_INV)?> Current date : <?xdoxslt:sysdate('DD-MON-YYYY HH24:MI')?><?xdoxslt:sysdate('Day Month DD,YYYY')?>
Format Number: <?format-number:field_name;'99G999G999G990D99'?><fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?field_number?></fo:bidi-override><?xdoxslt:set_variable($_XDOCTX,'V_OP',CS_OP_VAL_NEW)?>
<?xdoxslt:set_variable($_XDOCTX,'V_CLOS',CS_CL_VAL_NEW)?>
<?xdoxslt:get_variable($_XDOCTX,'V_OP')+RECEIPT_VAL-xdoxslt:get_variable($_XDOCTX,'V_CLOS')?> Sorting:<?sort:SOURCE1;'ascending';data-type='text'?><?xdoxslt:ifelse(condition,true,false)?> <?xdoxslt:ifelse(0=1,'yes 0 and 1 are equal','No 0 and 1 are not equal')?> <?xdoxslt:ifelse ((APR) != 0, xdoxslt:div((APR1)*100,(APR)),0)?> ---Not required- <?end if?><?xdofx:to_number()?> <?xdofx:if ../../../../CF_DOCUMENT ='STANDARD' or SECURITY_POR_PO_NUM!=''?> <?if: ../../../../CF_DOCUMENT ='STANDARD' or SECURITY_POR_PO_NUM!=''?> <?if: CF_ACC_CODE='Y' ?> <?call-template: code_y_acc_y?> <?end if?> <?if: CF_ACC_CODE='N' ?><?call-template: code_n_acc_n?> <?end if?>
<?choose:?><?when: CP_RUNFOR='AA'?> ... <?end when?><?when: CP_RUNFOR='BB'?>... <?end when?>
<?end choose?> <?xdoxslt:toWordsAmt(CS_IGST_AMT)?>
<?template:code_n_acc_n?>
<?end template?>
<?template:code_y_acc_y?>
<?end template?>
Last Page Only Content<?start@last-page:body?>
<?end body?>
HIDE the COLUMN from the RTF report in ORACLE
Goto the Column Heading and the type the Code like:
In
the if
field we type the code like:
<?if@column:/items/@type="PRIVATE"?>
In
the end if
field we type the code like:
<?end if?>
Then go to the row of open value field.
In
the if
field we type the code like:
<?if@column:/items/@type="PRIVATE"?>
In
the 20.00
field we type the code like:
<?if@column:/items/@type="PRIVATE"?> <?CF_OPENING_VAL?> <?end if?>
In
the end if
field we type the code like:
<?end if?>
Then go to the SUM total of the field and type the code like :
In
the if
field we type the code like:
<?if@column:/items/@type="PRIVATE"?>
In
the end if
field we type the code like:
<?end if?> Displaying image dynamically in XML Publisher (BI Tools) in RTF Template :
Right click on company logo image and click “Size” then goto “AltText” tab and enter dynamic path in “Alternative Text” field.e.g. url:{concat(‘${OA_MEDIA}’,’/JG_LOGO.jpg’)}. Dynamic Logo: url:{concat('$[OA_MEDIA]','/',//ORG_CODE)}
BI Publisher software Link