Dynamic column in table

 
I have a xml like this

----------------------------

<rprt> 
<buyr buyr_name="JC">
<ostl ostl_name="JC T-Shirt">

<colr colr_name="Green">

<size size_name="S" size_seqn="0" clsz_qnty="5000"
clsz_unit="PCS" clsz_rtio="0.5" />

<size size_name="M" size_seqn="1" clsz_qnty="5000"
clsz_unit="PCS" clsz_rtio="0.5" />

<size size_name="XL" size_seqn="3" clsz_qnty="4000"
clsz_unit="PCS" clsz_rtio="0.4" />

<size size_name="L" size_seqn="5" clsz_qnty="7000"
clsz_unit="PCS" clsz_rtio="0.7" />

</colr>

<colr colr_name="Baown/Beige Melange">

<size size_name="S" size_seqn="0" clsz_qnty="3000"
clsz_unit="PCS" clsz_rtio="0.3" />

<size size_name="M" size_seqn="1" clsz_qnty="6000"
clsz_unit="PCS" clsz_rtio="0.6" />

<size size_name="XL" size_seqn="3" clsz_qnty="7000"
clsz_unit="PCS" clsz_rtio="0.7" />

<size size_name="L" size_seqn="5" clsz_qnty="5000"
clsz_unit="PCS" clsz_rtio="0.5" />

<size size_name="XXL" size_seqn="5" clsz_qnty="3000"
clsz_unit="PCS" clsz_rtio="0.8" />

</colr>

</ostl>

 

<ostl ostl_name="Trouser" >

<colr colr_name="01/Black">

<size size_name="S" size_seqn="0" clsz_qnty="2250"
clsz_unit="PCS" clsz_rtio="1" />

<size size_name="M" size_seqn="1" clsz_qnty="4500"
clsz_unit="PCS" clsz_rtio="2" />

<size size_name="XL" size_seqn="3" clsz_qnty="6750"
clsz_unit="PCS" clsz_rtio="3" />

<size size_name="L" size_seqn="5" clsz_qnty="4500"
clsz_unit="PCS" clsz_rtio="2" />

</colr>

<colr colr_name="12 Blue Denim">

<size size_name="S" size_seqn="0" clsz_qnty="4500"
clsz_unit="PCS" clsz_rtio="2" />

<size size_name="M" size_seqn="1" clsz_qnty="2250"
clsz_unit="PCS" clsz_rtio="1" />

</ostl>
</buyr>
<buyr>
..
..

</buyr> 
</rprt>


------------------------


I have to create a table like spreadsheet for each
ostl. Can anyone help me with a

example of xsl-fo file or xsl file. Output will be
like this

 

 

Color\Size         S          M         XL         L  
       XXL       Total

 

Green               5000     5000     4000     7000   
 0          21000

 

Baown/             3000     6000     7000     5000    
3000     24000

Beige Melange

 

Total                 8000     11000   11000   12000  
3000     45000

 

Thanks in advance.

 

Shabbir


__________________________________________________
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com

 XSL-List info and archive:  http://www.mulberrytech.com/xsl/xsl-list