Displaying subtotal and grand total based on the group column in BI Publisher Template

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

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

 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)


  • January 11, 2015 | 91 views