Sunday, 11 January 2015

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




10 comments:

  1. what is content in ACC xml tag? I tried like that but it for each one group only.

    ReplyDelete
  2. Hi, DoyenTeam ,Could you kindly please send the RTF template to my email? That would be very nice of you.Thanks.
    jack.cui@greaconsulting.com

    ReplyDelete
  3. Regards
    Sridevi Koduru (Senior Oracle Apps Trainer Oracleappstechnical.com)
    LinkedIn profile - https://in.linkedin.com/in/sridevi-koduru-9b876a8b
    Please Contact for One to One Online Training on Oracle Apps Technical, Financials, SCM, SQL, PL/SQL, D2K at training@oracleappstechnical.com | +91 - 9581017828.

    ReplyDelete
  4. Thanks for sharing artile about OCI Punchout
    cXML PunchOut

    ReplyDelete
  5. Thanks for sharing artile about OCI Punchout
    cXML PunchOut

    ReplyDelete
  6. OCI PunchOut - Vurbis Interactive used OCI PunchOut, Punchout cXML, cXML Punchout, cXML Ariba, cXML protocols created by Ariba in 1999 for business communications.
    OCI PunchOut

    ReplyDelete
  7. Vurbis Interactive used punchout cxml protocol developed by Ariba which helps for online shopping and ordering between e-procurement systems.
    PunchOut cXML

    ReplyDelete