For Example
Display the sub total values based on
Account code and show grand total end of the report.
Account code and show grand total end of the report.
The report has only one group (G_ACCT)
and group columns like
and group columns like
Account Code, Ro Number, ROLine# ,Ro Type, Ro Date, Supplier#, Supplier
Name,
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.
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:
- <?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)
Output:
Recommended Posts