Running Total in BI Publisher Reports

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.