Grouping records

[ChewDoggie]

G'morning all,

I have a CR (CRXI) "Labor" report and the mgmnt wants the report summarized by SHIFT.

The challenge (at least to me b/c I'm a CR Newbie) is that the shift information is in a field that needs to be parsed. Currently, the Shift info is a Formula field that looks like this:

IF RIGHT({VP_TOTALS.LABORLEVELNAME3}, 1) = "A" THEN
    "1st Shift"
ELSE IF RIGHT({VP_TOTALS.LABORLEVELNAME3}, 1) = "B" THEN
    "2nd Shift"
ELSE
    "3rd Shift"

But now I have to GROUP these records by SHIFT. How do I perform GROUPING by "1st Shift", "2nd Shift" or "3rd Shift" ?

Thanks !

Chew

10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[lbass]

Insert a group on your formula.

-LB

 

[ChewDoggie]

Thank you, lbass. It had been a few hours since my post so I started a new report and ran smack into the middle of my last problem I posted, "Edit running total field".

Chew

10% of your life is what happens to you. 90% of your life is how you deal with it.

 

[lbass]

How does your response relate to the current thread? Did you figure out how to insert a group?

-LB

 

[ChewDoggie]

Sorry for not replying sooner. I redesigned my form and placed a 'Dept' group on the form and then went with running totals across the page per my other post.

C.


10% of your life is what happens to you. 90% of your life is how you deal with it.