How to show the last Operation and Status based on Last Work Date 1

[rwn]

I have a report that needs to show each Jobs last Operation worked. But it to only show the last operation of each Job based on the Last Work Date entry field for the Jobs Operation. The fields are:
Job Operation Sequence - Job Operation Work Center - Job Operation Last Work Date and Job Operation Status.
I tried these two formulas:
This one to show the last work center worked:
@MAXWorkCenter
if {Job_Operation_Time.Last_Updated} = Maximum ({Job_Operation_Time.Last_Updated}, {Job.Job})
then {Job_Operation.Work_Center}
-------
This one to show the last work center worked Status:
@JobOpStatus
if {Job_Operation.Status} = "O" then "OPEN"

else if {Job_Operation.Status} = "S" then "INPRO"

else if {Job_Operation.Status} = "C" then "COMPLETE"
else if {Job_Operation.Status} = "T" then "INPRO"

The fields are place in the GF1(Job) and the details section is suppressed.

Thanks for any advice!

 

[lbass]

Instead of all of these formulas, you could just sort by date ascending, and then place the fields in the group footer.

-LB

 

[rwn]

How funny, when one is to close to the issue one forgets to view it correctly. The simple approach vs all the formulas. I will try and get back to you. Thanks again!