Need to combine hours by work class

[PBTX]

Below is how my report is displaying. I need to combine all the driver hours into a total. I have tried sum, total and I must not be using the right codes, as it gives me a total underneath the individual total.

Period_End_Date Race Job_Number WorkClass Hours
5/28/2011 C 4250 Driver 3.50

05/29/2011 H Driver 7.00

05/30/11 ASAM Driver 6.00

05/28/11 C Operator 3.00

05/29/11 C Operator 6.00

05/29/11 C Laborer 2.50

Thank you,

 

[lbass]

Create a formula like this:

if {table.workclass} = "Driver" then
{table.hours}

Place it in the detail section and insert a sum on it at the group or report level.

Alternatively, if you want sums by each workclass, insert a group on that field and insert a sum on hours at the workclass group level.

-LB

 

[PBTX]

Did not work. The work class is actually the union code converted to text.
if isnull({PR_Time_Card_History_MC.Union_Code}) then
"" else
(
select mid({PR_Time_Card_History_MC.Union_Code},2,1)
case "D" : "Driver"
case "O" : "Operator"
case "L" : "Laborer"
case "F" : "Foreman"
)

If I attempt to add it in here it gives me error messages. If I add it to Group 1 it moves all my union codes to the left
0.00
SCHIJON
1.50
SCHIJON
2.00
SCHIJON
SCHIJON C 5/28/2011 12:00:00AM 4250 Driver 3.50
0.00
LAFATRA
1.08
LAFATRA
LAFATRA C 6/11/2011 12:00:00AM 4250 Driver 1.08
0.00
NAVAALB
1.00
NAVAALB
NAVAALB H 6/18/2011 12:00:00AM 4250 Driver 1.00
0.00
FISHCOR
1.00
FISHCOR
FISHCOR C 5/28/2011 12:00:00AM 4250 Driver 1.00
0.00
RAVERON
0.50
RAVERON
1.00
RAVERON
1.50
RAVERON
2.00
RAVERON
2.50
RAVERON
3.00
RAVERON
3.50
RAVERON
4.00
RAVERON
4.50
RAVERON
5.00
RAVERON
7.00
RAVERON
Employee_Code Race Period_End_Date Job_Number Work Class Hours
4250 MEUR
8.00
RAVERON
10.00
RAVERON
RAVERON C 6/18/2011 12:00:00AM 4250 Foreman 176.00

Arrgh!

 

[lbass]

I have no idea what you are saying about things moving to the left. You should be referencing your formula--I'll call it {@unioncode}:

if {@unioncode} = "Driver" then
{table.hours}

Place this formula in the detail section->right click on it->insert summary->sum and choose the group and/or report level where you want the results.

-LB

 

[PBTX]

The following is my formula in the @union

if isnull({PR_Time_Card_History_MC.Union_Code}) then
"" else
(
select mid({PR_Time_Card_History_MC.Union_Code},2,1)
case "D" : "Driver"
case "O" : "Operator"
case "L" : "Laborer"
case "F" : "Foreman"
);
if {PR_TIME_CARD_HISTORY_MC.Union_Code} = "Driver" then
{PR_TIME_CARD_HISTORY_MC.Hours};
if {PR_TIME_CARD_HISTORY_MC.Union_Code} = "Laborer" then
{PR_TIME_CARD_HISTORY_MC.Hours};

I have Group header 1 which is Job Number
Group Header 2 which is Employee code.

Thank you, for your help with this.


if {PR_TIME_CARD_HISTORY_MC.Union_Code} = "Operator" then
{PR_TIME_CARD_HISTORY_MC.Hours}

the results = all my union codes change to 0.00

 

[lbass]

I don't know what the end product is supposed to look like, but instead of the approach you are using, try adding the following formula as a row field in a crosstab that you insert in the report footer, and use sum of {PR_TIME_CARD_HISTORY_MC.Hours} as the summary field, with no column field:

if isnull({PR_Time_Card_History_MC.Union_Code}) then
"" else
(
select mid({PR_Time_Card_History_MC.Union_Code},2,1)
case "D" : "Driver"
case "O" : "Operator"
case "L" : "Laborer"
case "F" : "Foreman"
)

-LB