<p>HI, All,</p>
<p>Here is the report should look like:</p>
<p> </p>
<p>Type WOClosed WOApproved WOScheduled Maintenance</p>
<p> </p>
<p>Elect 100 200 300 900</p>
<p>Safety 200 300 400 600</p>
<p>Grand Total 300 500 700 1500</p>
<p> </p>
<p>For "WOClosed WOApproved WOScheduled Maintenance" , they are calculated based on different conditions, for example, WOClosed= sum (costA+costB+costC) where the wo.status = 'close'.</p>
<p> </p>
<p>Does it need java script? or any ideas instead of Grid or cross tab?</p>
<p>Any help is appreciated!</p>
