Thursday, 4 May 2017

Oracle XML Tags Example

<?for-each:G_1?>

<?end for-each?> 

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

<xsl:value-of select="position()"/>

<?sum(current-group()/LINE_AMT)?> 

 

<?xdoxslt:sysdate('DD-MON-YYYY HH24:MI')?>

 

<?format-number:field_name;'99G999G999G990D99'?>

 

<?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_VAL1 - xdoxslt:get_variable($_XDOCTX,'V_CLOS')?>

 

<?sort:current-group()/ITEM_NAME;'ascending';data-type='text'?> 

 

<?xdoxslt:ifelse ((APR) != 0, xdoxslt:div((APR1)*100,(APR)),0)?>

 

<?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?>



<?xdoxslt:toWordsAmt(CS_IGST_AMT)?>

<?template:code_n_acc_n?>

<?end template?>

 

<?template:code_y_acc_y?>

<?end template?>




How to HIDE the COLUMN from the RTF report in ORACLE?
ANS: I am HIDE the Open Value column in rtf.
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?>

No comments:

Post a Comment