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.