Case logic help

[BigBurcie]

I am trying to make a report that summarizes operating days and revenue for equipment grouped by the business unit they belong to.

I am displaying them in crystal as several fields under a unit type heading. It should be somewhat like this.

700 900 .....
Op Days 4 5
Revenue $5000 $7000
...

Here is how I am doing it now:
Sum(case Unit
When 700 then OpDays
else 0
End)
Sum(case Unit
When 700 then OpRevenue
else 0
end)
sum(case Unit
When 900 then OpDays
else 0
end)
...


I would like to combine each field for type 700 under one case statement, all fields for 900 under one case....

Any thoughts?

 

[rmnastor]

You might not need to use the case on this matter... mail me a sample of the database and your output i might give u a better query...