xsl-list
[Top] [All Lists]

Show a column only if the total is not zero

2004-05-18 06:10:23
The costs on a project look like this.

<person>
   <name>Adam</name>
   <fees>134.25</fees>
   <overtime>0.00</overtime>
   <travel>39.25</travel>
</person>
<person>
   <name>Brian</name>
   <fees>172.50</fees>
   <overtime>0.00</overtime>
   <travel>52.75</travel>
</person>
<person>
   <name>Chris</name>
   <fees>103.75</fees>
   <overtime>0.00</overtime>
   <travel>0.00</travel>
</person>

I would like the report on the project to look like this.

name            fees            travel
Adam            134.25          39.25
Brian           172.50          52.75
Chris           103.75          0.00
Total           410.50          92.00

There was no overtime on this project so I don't want it shown. I should
be most grateful for any suggestions on the best way to show the columns
where the total is not zero. (In practice I have more than 3 types of
cost.) 
Many thanks.


<Prev in Thread] Current Thread [Next in Thread>