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.
- 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:
- <?for-each-group:G_ACCT;./ACCOUNT_CODE?> (first F Xml tag)
- <?for-each:current-group()?>(second F xml tag)
- After displaying G_AMT Closing current-group for-each.
- Displaying the T_AMT (grand total amount)