faisalsham
Programmer
hello,
I need to come up with the following report but have a difficult time. Here are the Columns and a sample data set:
Work Unit Open WO Closed WO
--------- --------- ---------
Electrical 5 2
Carpentary 3 5
Sign Shop 10 4
.
.
.
as you can see the grouping needs to be done on the Work Unit, but then I need to sum up the Open and Closed Work Orders for each Work Unit. Can you please help me on how can I sum up the Open and Closed Work Orders for each unit?
So for example Electrical... I need to be able to count the number of Open Work Orders in the database and display the 5 and count the number of closed Work Orders and display the 2 according to the example above.
thanks for your help.
I need to come up with the following report but have a difficult time. Here are the Columns and a sample data set:
Work Unit Open WO Closed WO
--------- --------- ---------
Electrical 5 2
Carpentary 3 5
Sign Shop 10 4
.
.
.
as you can see the grouping needs to be done on the Work Unit, but then I need to sum up the Open and Closed Work Orders for each Work Unit. Can you please help me on how can I sum up the Open and Closed Work Orders for each unit?
So for example Electrical... I need to be able to count the number of Open Work Orders in the database and display the 5 and count the number of closed Work Orders and display the 2 according to the example above.
thanks for your help.