summarizing and filtering by Previous(field) statements

[tkaplanusmc]

using CR 11. I am trying to create a report that shows the correct order of jobs by sequence and current workcenter thats next up on the sequence list. I am using this formula to calculate the workcenter next up on the worklist:

if Previous({Job_Operation.Status}) = "C"
and {Job_Operation.Status} = "O" then true

based on this calculation im trying to display only the workcenters that meet the true statement, and summarize all the current jobs in that workcenter based on this sequence

additionally i need to take these sequential jobs and determine which are late based on the formula below:

if {Job_Operation.Work_Center} = "Planning"
and{Delivery.Promised_Date} <= today -27 then 1
else if {Job_Operation.Work_Center} = "Purchasing"
and{Delivery.Promised_Date} <= today -24 then 1
else if {Job_Operation.Work_Center} = "Contracts"
and{Delivery.Promised_Date} <= today -28 then 1
else if {Job_Operation.Work_Center} = "Program"
and{Delivery.Promised_Date} <= today -24 then 1
else if {Job_Operation.Work_Center} = "Review"
and{Delivery.Promised_Date} <= today -23 then 1
........(Continued)........

any assistance would be greatly appreciated i have no idea where to go from here.

 

[lbass]

You could use a suppression formula like this on the detail section:

not(
Previous({Job_Operation.Status}) = "C" and
{Job_Operation.Status} = "O"
)

I think you could insert a running total that does a sum of your formula, evaluates using a formula:

Previous({Job_Operation.Status}) = "C" and
{Job_Operation.Status} = "O"

Reset never (if you want the result at the report level). Place the running total in the report footer.

-LB

 

[tkaplanusmc]

Thanks lbass these formulas indeed work but i'm still racking my brain here on how im supposed to get this to work. i have two big problems.

problem one is that in order to get these formulas to work i need to get everything in sequential order grouped by job number, whereas what i need is for the report to group by work center and total jobs assigned to work centers based on where they fall in the order of sequences per job (**note the sequence is not the same for all jobs**).

problem two is that the formula determines the proper sequence on print time so i am unable to produce a sum in the group header because of this.

 

[lbass]

You need to provide some (labeled) sample data and then show a second set with how you want the results to look.

-LB

 

[tkaplanusmc]

i need it to look something like this, but with the sequence order i described above. select expert formulas currently being used include.

record selection:
if {Job.Open_Operations} <> 0
and {Job_Operation.Work_Center} <> ""
and {Job_Operation.Status} = "O"
and {Job.Status} = "Active" then true



Work Center Total Jobs Per Work Ce sum Late Jobs

CONTRACTS 2 0
Job Promised date @late
14957-R 6/18/2010 0.00


15807 6/18/2010 0.00


PLANNING 22 0

15120 8/2/2010 0.00


15753 7/30/2010 0.00


15755 8/6/2010 0.00


15756 7/30/2010 0.00

@late formula
if {Job_Operation.Work_Center} = "Planning"
and{Delivery.Promised_Date} <= today -27 then 1
else if {Job_Operation.Work_Center} = "Purchasing"
and{Delivery.Promised_Date} <= today -24 then 1
else if {Job_Operation.Work_Center} = "Contracts"
and{Delivery.Promised_Date} <= today -28 then 1
.....Continued.....

 

[tkaplanusmc]

the formulas only seem to work when the report is layed out like this:


Work_Center sequence Status sequence late
11111 (sum) 0 (sum)2.00

TIG WELD 0 O 0.00

INSPECTION 1 O 0.00 1.00

INSPECTION 3 O 0.00 1.00

STAGE 4 O 0.00 0.00

11279 (sum)1 (sum)3.00

MACHINING 0 C 0.00 1.00

DEBURR 1 O 1.00 1.00

INSPECTION 2 O 0.00 1.00

STAGE 3 O 0.00 0.00

 

[lbass]

You need to show all relevant fields in your sample data, including seq no and status--you provided these in your last sample, but not in the one that shows how you want it to look, and I have no idea how they relate to each other. What field are you grouping on, what are you sorting on, and what question is the report supposed to answer?

-LB