XML Running Total


Running Totals
---------------------------
Set variable A=Sum(invoice_amount)
Set variable B=Sum(amount_paid)
Set variable C=get variable A+get variable B
Get variable c
<?xdoxslt:set_variable($_XDOCTX,'A',sum(CF_30_WRIONOFF))?>
<?xdoxslt:set_variable($_XDOCTX,'B',sum(CS_SUM_NFR))?>
<?xdoxslt:set_variable($_XDOCTX,'C',xdoxslt:get_variable($_XDOCTX,'A')+xdoxslt:get_variable($_XDOCTX,'B'))?>
<?xdoxslt:get_variable($_XDOCTX,'x_rev')?>
2/ Number format

 <?format-NUMBER:INVOICE_AMOUNT;’999G990D99’?>
3/Dynamic title in the header(use direct insertion of tag,here form text filed wont work,It is disabled)
4/Table auto format.
5/Wizard table insertion
Note : If multiple groups are there(more than 5), press down arrow .
6/supplier wise total  (sum(invoi_amount) in the loop) – SUB TOTAL
9/Report total (sum(invoi_amount) out of  the loop) – REPORT TOTAL
10/While using SUM operator,Every columns shoul have value.If null is there it will return NaN.To Avoid NaN we should use NVL function in query itself.
11/ Repetation of headers for each and every page
Table contrl(+),Right click,Table properties,Navigate to Row Tab,Check the check box Repeat as header row at the top of each page
12/Tools==> filed browser ,to update the exsiting xml code
13/Hide fields it does not fetch any data
14/Matrix Report
    Section (XMLP)– Row(RDF)
    Column
Cell
Source Name
G SOURCE_MONTH E
Total
 GROUP JE_SOURCE
Gif exists JE_COUNT end  E
  999 E
Total
G if exists 999  end E


15.RW Convereter (Available on R12 only)
   It will provide template for any RDF.
Oracle java parser
16.XDODTEXE
  JAVA Concurrent program
17/Multilanguas –Translatable option.

No comments:

Post a Comment

How to find all cancel Requisitions

SELECT prha . *   FROM po_Requisition_headers_all prha , po_action_history pah   WHERE      1 = 1        AND pah . object_id ...