BI Publisher: Apply formatting on Group of rows based on data

Output Needed:

Quick Summary of Steps:

Detail of each step:

1. InitVarBIDNO
<?xdoxslt:set_variable($_XDOCTX, 'PREV_BIDNO', '0')?>


2. InitVarCount: 
<?xdoxslt:set_variable($_XDOCTX, 'XXCOUNT', 1)?>


3. For Each
<?for-each:G_BOARD_DOC?>  
<?sort:MASTER_RFQ_NUM;'ascending';data-type='text'?> 
<?sort:BDOC_TYPE;'descending';data-type='text'?> 
<?sort:VENDOR_NAME;'ascending';data-type='text'?>

4.UpdateBdocCount
<?if:xdoxslt:get_variable($_XDOCTX,'PREV_BIDNO')!=MASTER_RFQ_NUM?><?xdoxslt:set_variable($_XDOCTX, 'XXCOUNT', xdoxslt:get_variable($_XDOCTX,'XXCOUNT')+1)?><?end if?>


5. IfSameBdocAsPreviousRow
<?if@row:xdoxslt:get_variable($_XDOCTX,'XXCOUNT') mod 2=0?>
<xsl:attribute name="color" xdofo:ctx="incontext">rgb(153, 0, 0)</xsl:attribute>
<?end if?>


6. UpdatePrevValue
<?xdoxslt:set_variable($_XDOCTX, 'PREV_BIDNO',MASTER_RFQ_NUM)?>