How To make Matrix Report in oracle R12 ( Example : for Quotation No with Nos of Vendor Wise)

Matrix Report Excel Output In Oracle Apps (R12)

for Quotation No with Nos of Vendor Wise

Write the Query in .rdf 

 

Design the .rtf file like that

H SL No.

Where H  means

<?horizontal-break-table:1?>

This is for Horizontal Breaks the Table.

for: Vender_Name end

for: Vender_Name end

 Here

 for :

<?for-each-group@column:G_RFQ_NO1;VENDOR_NAME1?>     <?sort:VENDOR_NAME1;'ascending';data-type='text'?>

G_RFQ_NO1                      : is the Report Level Group Name

VENDOR_NAME1            :  is the Matrix for Quotations

data-type='text'               :  text because Vender name is text, if I use Vender Id then It is Number.

Vender_Name : <?VENDOR_NAME1?>

end : <?end for-each-group?>

 

for:   Quote QTY

Discount (%)

Unit Price  Breaks (BDT)

Total Price (BDT)end

Here

for :

<?for-each-group@cell://G_RFQ_NO1;./VENDOR_NAME1?>        <?sort:VENDOR_NAME1;'ascending';data-type='text'?>

Here 

for-each-group@cell://G_RFQ_NO1;./VENDOR_NAME1

here It repeat the cell how many venders are there.

end <?end for-each-group?>

for:  sno

RFQ_NO1

Item_NAME

ITEM_DESCRIPTION

UNIT_PRICE

for:  0.00

0.00

0.00

0.00 end end

for: sno RFQ_NO1 Item_NAME ITEM_DESCRIPTION for:  0.00 0.00 0.00 end end

Here

for:

<?for-each-group@section:G_RFQ_NO1;./ ID?><?variable@incontext:DESC;ID?>

Here ID is the Most Important Things. So that we create the ID in Report Level for Unique Data.

LIKE :

(rfq_part.ITEM_NAME|| rfq_part.ITEM_DESCRIPTION|| quote_part.quote_quantity || rfq_part.UOM ||quote_part.price_override)  ID

sno  <xsl:value-of select="position()"/>

Generated the Serial No.

RFQ_NO1 :  <?RFQ_NO1?>

Item_NAME : <?ITEM_NAME?>

ITEM_DESCRIPTION : <?ITEM_DESCRIPTION?>

for:  

<?for-each-group@cell://G_RFQ_NO1;./VENDOR_NAME1?>        <?sort:VENDOR_NAME1;'ascending';data-type='text'?>

for-each-group@cell://G_RFQ_NO1;./VENDOR_NAME1

here It repeat the cell how many venders are there.

0.00

<?if:count(current-group()[ID=$DESC])?>  <?sum(current-group()[ID=$DESC]/QUOTE_QUANTITY)?> <?end if?>

It Calculate the sum of  “QUOTE_QUANTITY”

0.00

<?if:count(current-group()[ID=$DESC])?>  <?sum(current-group()[ID=$DESC]/PRICE_DISCOUNT)?>  <?end if?>

It Calculate the sum of  “PRICE_DISCOUNT”

0.00

<?if:count(current-group()[ID=$DESC])?>  <?sum(current-group()[ID=$DESC]/TOTAL_PRICE)?>  <?end if?>

It Calculate the sum of  “TOTAL_PRICE”

end

<?end for-each-group?>

end

<?end for-each-group?>

Total Price

for:  0.00

0.00

0.00

0.00 end

Total Price

for:  0.00 0.00 end

for:

<?for-each-group@cell://G_RFQ_NO1;./VENDOR_NAME1?>        <?sort:VENDOR_NAME1;'ascending';data-type='text'?>

for-each-group@cell://G_RFQ_NO1;./VENDOR_NAME1

here It repeat the cell how many venders are there.

0.00

<?sum(current-group()/QUOTE_QUANTITY)?>

Sum Total of  “QUOTE_QUANTITY”

0.00

<?sum(current-group()/TOTAL_PRICE)?>

Sum Total of  “TOTAL_PRICE”

end

<?end for-each-group?>

Out Put of the Matrix Report In Excel Sheet.