In report builder you can create a priority dispatch by:
Master table = JobOper
Join to the JobOper from JobOper using Alias name of JobOper2, Company =
Company, job = job.
Now for each JobOper record you will get all the operations for the job.
Add in the filter JobOper.OprSeq > JobOper2.OperSeq.
Now for each JobOper record you will get just prior operations.
Display your JOBOPER on a GROUP FOOTER and JobOper2 on the record line.
You will turn off the record line when finished unless you want to see all
prior operaitons.
Create calculated fields for information you need from a prior operation
using the PREVIOUS command.
Prior_Qty_Complete = PREVIOUS(JobOper.QtyCompleted)
You can even look back two operations:
PREVIOUS(PREVIOUS(JobOper.QtyCompleted))
I my company if the prior operation is a 15 minute task like WASH parts we
look back two operations to see if the parts are on their way.
Have fun.
Patrick Winter
-----Original Message-----
From: melmike13 <mikeg.ptc@...> [mailto:mikeg.ptc@...]
Sent: Monday, February 03, 2003 4:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch
Has anyone been able to write their own priority dispatch report? We
are running 5.1 and our "out of the box" report is getting confused
by our need to cascade operations--having more than one operation
running at a time. By having more that one operation open at a time
we are showing the job becoming available in the next operation step
that hasn't started yet. Often times this step is the final step,
and this wouldn't become valid until all of the parts have completed
on each of the previous steps. I guess that I'm looking for a filter
of some kind.
Thanks,
Mike Gilchrist
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
Master table = JobOper
Join to the JobOper from JobOper using Alias name of JobOper2, Company =
Company, job = job.
Now for each JobOper record you will get all the operations for the job.
Add in the filter JobOper.OprSeq > JobOper2.OperSeq.
Now for each JobOper record you will get just prior operations.
Display your JOBOPER on a GROUP FOOTER and JobOper2 on the record line.
You will turn off the record line when finished unless you want to see all
prior operaitons.
Create calculated fields for information you need from a prior operation
using the PREVIOUS command.
Prior_Qty_Complete = PREVIOUS(JobOper.QtyCompleted)
You can even look back two operations:
PREVIOUS(PREVIOUS(JobOper.QtyCompleted))
I my company if the prior operation is a 15 minute task like WASH parts we
look back two operations to see if the parts are on their way.
Have fun.
Patrick Winter
-----Original Message-----
From: melmike13 <mikeg.ptc@...> [mailto:mikeg.ptc@...]
Sent: Monday, February 03, 2003 4:44 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch
Has anyone been able to write their own priority dispatch report? We
are running 5.1 and our "out of the box" report is getting confused
by our need to cascade operations--having more than one operation
running at a time. By having more that one operation open at a time
we are showing the job becoming available in the next operation step
that hasn't started yet. Often times this step is the final step,
and this wouldn't become valid until all of the parts have completed
on each of the previous steps. I guess that I'm looking for a filter
of some kind.
Thanks,
Mike Gilchrist
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/