XSL FO Table formatting

davedran · Dec 13th, 2006, 07:35

Hi!

Help, I think there is a simple solution for this. Can't seem to format this correctly

Thanks alot.

Dave

<fo:table width="100%">
<fo:table-column column-width="proportional-column-width(50)"/>
<fo:table-column column-width="proportional-column-width(25)"/>
<fo:table-column column-width="proportional-column-width(25)"/>
<fo:table-body>
<xsl:for-each select="//DscA | //DscB">
<fo:table-row line-height="13pt">
<fo:table-cell border-width="1pt" border-style="solid">
<fo:block>
<xsl:value-of select="."/>
</fo:block>
</fo:table-cell>
</fo:table-row>
</xsl:for-each>
</fo:table-body>
</fo:table>

Actual XML Data
<DscA>1. Money In Premises</DscA>
<DscA>3,000.00</DscA>
<DscA>0.00</DscA>
<DscA>2. Money In Transit</DscA>
<DscB>3,000.00</DscB>
<DscB>0.00</DscB>
<DscB>3. Others</DscB>
<DscB>10,000.00</DscB>
<DscB>0.00</DscB>

The expected output (3 columns

1. Money In Premises 3,000.00 0.00
2. Money In Transit 3,000.00 0.00
3. Others 10,000.00 0.00

The current output

1. Money In Premises
3,000.00
0.00
2. Money In Transit
3,000.00
0.00
3. Others
10,000.00
0.00
TOTAL