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?>
HI
ReplyDeletecan you please send me the template? I am working on matrix style financial report and looking out for XML type template
deepak.gagoria@gmail.com
Deletehi how build matrix aml template query have multiple group by columns.plase help me its urgent my mail id:sunitha.mca119@gmail.com
ReplyDeleteThis comment has been removed by the author.
ReplyDeleteLIKE YOUR QPRICE I HAVE A COUNT COLOUMN BUT IT DOES NOT RETUR ANY VALUE PLEASE HELP ME ITS URGENT
ReplyDeleteQueries
ReplyDeleteSaturday, 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