For Example

Display the sub total values based on
Account code and show grand total end of the report.

The report has only one group (G_ACCT)
and  group columns like 
     Account Code, Ro Number, ROLine# ,Ro Type, Ro Date, Supplier#, Supplier
Name, 
     Supplier Site, W/H, Buyer, Items, Qty, Price, Trxn Amount

Show the subtotal and grand total amount
for Trxn amount column based on account code combination.

Steps:
  • Divide the for –each loop with Account code
    column
  • Do the current group logic.
  • Display the sub total column before closing
    current group loop.
  • Display the grand total value at end of the
    report.

 Adding above steps logic in xml tags:

  1.      <?for-each-group:G_ACCT;./ACCOUNT_CODE?>
    (first F Xml tag)
  2.      <?for-each:current-group()?>(second
    F xml tag)
  3.       After displaying G_AMT Closing
    current-group for-each.
  4.       Displaying the 
    T_AMT (grand total amount)

Output:


Recommended Posts

Start typing and press Enter to search