Saturday, 28 December 2013

XML Publisher Matrix Report: Cross Tab layout in XML Publisher

A sample layout for XML Publisher Matrix Report.The purpose of the report is to display the quoted price and negotiated price of an item from different suppliers.



Following are the tags used.

headercolumn = <?horizontal-break-table:1?>

for1 = <?for-each-group@section:G_QUOTATION;DESCRIPTION?>   <?variable@incontext:DES;DESCRIPTION?>

for2 = <?for-each-group@column:  G_QUOTATION;VENDOR_NAME?> <?end for-each-group?>

for3 = <?for-each-group@cell://G_QUOTATION;VENDOR_NAME?> <?end for-each-group?>

for4 = <?for-each-group@cell://G_QUOTATION;VENDOR_NAME?> <?end for-each-group?>

for5 = <?for-each-group@cell://G_QUOTATION;VENDOR_NAME?> <?end for-each-group?>


QPRICE = <?if:count(current-group()[DESCRIPTION=$DES])?>  <?current-group()[DESCRIPTION=$DES]/QUOTE_PRICE?>  <?end if?>                         

For6 = <?for-each-group@cell:G_QUOTATION;VENDOR_NAME?>   <?variable@incontext:VEN;VENDOR_NAME?>

                                                                                      
Sum(QPRICE) = <?if:count(current-group()[VENDOR_NAME=$VEN])?>  <?sum(current-group()[VENDOR_NAME=$VEN]/QUOTE_PRICE)?>  <?end if?> 



                  

6 comments:

  1. HI

    can you please send me the template? I am working on matrix style financial report and looking out for XML type template

    ReplyDelete
  2. hi how build matrix aml template query have multiple group by columns.plase help me its urgent my mail id:sunitha.mca119@gmail.com

    ReplyDelete
  3. This comment has been removed by the author.

    ReplyDelete
  4. LIKE YOUR QPRICE I HAVE A COUNT COLOUMN BUT IT DOES NOT RETUR ANY VALUE PLEASE HELP ME ITS URGENT

    ReplyDelete
  5. Queries

    Saturday, 28 December 2013
    XML Publisher Matrix Report: Cross Tab layout in XML Publisher
    A sample layout for XML Publisher Matrix Report.The purpose of the report is to display the quoted price and negotiated price of an item from different suppliers.




    Following are the tags used.

    headercolumn =

    for1 =

    for2 =

    for3 =

    for4 =

    for5 =


    QPRICE =

    For6 =


    Sum(QPRICE) =




    Posted by Sethu at 01:47
    Email This
    BlogThis!
    Share to Twitter
    Share to Facebook
    Share to Pinterest
    6 comments:

    Deepak Sharma10 August 2016 at 06:49
    HI

    can you please send me the template? I am working on matrix style financial report and looking out for XML type template

    Reply
    Replies

    Deepak Sharma10 August 2016 at 06:49
    deepak.gagoria@gmail.com

    Reply

    Unknown16 August 2016 at 06:30
    hi how build matrix aml template query have multiple group by columns.plase help me its urgent my mail id:sunitha.mca119@gmail.com

    Reply

    Sridevi K22 September 2016 at 23:40
    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.

    Reply

    YahYa Khan22 November 2018 at 04:40
    This comment has been removed by the author.

    Reply

    YahYa Khan22 November 2018 at 04:41
    LIKE YOUR QPRICE I HAVE A COUNT COLOUMN BUT IT DOES NOT RETUR ANY VALUE PLEASE HELP ME ITS URGENT

    ReplyDelete