Thursday, 2 July 2015

Create Running Total Or Create Variables Values In Oracle XML Report

Running Total OR Variables Values
The variable functionality can be used to add a running total to your invoice listing report.

<?xml version="1.0" encoding="WINDOWS-1252"?>
<INVOICES>
 <INVOICE>
  <INVNUM>10001-BRIJESH</INVNUM>
  <INVDATE>1-Jan-2005</INVDATE>
  <INVOICEAMT>100</INVOICEAMT>
 </INVOICE>
 <INVOICE>
  <INVNUM>10001-TESTING</INVNUM>
  <INVDATE>10-Jan-2005</INVDATE>
  <INVOICEAMT>200</INVOICEAMT>
 </INVOICE>
 <INVOICE>
  <INVNUM>10001-REPORT</INVNUM>
  <INVDATE>11-Jan-2005</INVDATE>
  <INVOICEAMT>150</INVOICEAMT>
 </INVOICE>
</INVOICES>

And Create rtf layout and use Variables  function.

To create the Running Total field, define a variable to track the total and initialize it to 0.
Output.




No comments:

Post a Comment