Description:
Business information processing requires advanced calculations, including complex ranking, subtotals, moving averages, and lead/lag comparisons. These aggregation and analysis tasks are essential in creating business intelligence queries, and are accomplished by the use of window functions.
For Example
Display the subtotal values based on Account code and show the 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 subtotal column before closing the current group loop.
- Display the grand total value at the 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:
Summary:
This Post explained what the steps should follow for displaying subtotal and grand total based on the group column
Queries?
Do drop a note by writing us at contact@doyensys.com or use the comment section below to ask your questions.
