To create this is report builder give this a try:
Start with the JobOper table.
Filter for operations with labor or qty > 0. (Active Stuff)
Create a calculated called CurrentOper = JobOper.JobNumber +
String(JobOper.OprSeq,'9999')
Sort and Group on this field.
Add a Group Footer line on your report for this group.
Add the fields for Job, Oper, Sequence, WC, etc... On this
row.
Create an alias table join from JobOper to JobOper calling it
JobOper2.
Use the company and job fields.
Add a filter for JobOper.OprSeq > JobOper.OperSeq2.
(No you get just the prior operations)
Add JobOper2 fields to the record row such as OperSeq, WC,
operation comlete.
(Make sure record lines have JobOper2 fields not
JobOper)
Print Preview
The report should show an operation sequence on the group footer line
And all the prior operations listed above it on the record lines that print.
Now use the previous command in a calcualted field.
PriorComplete = PREVIOUS(JobOper2.OperationComplete)
This should get you pretty close.
Also when the report works just turn off printing record lines and all you
get are the
Group footer lines which are the exceptions your looking for.
Patrick Winter
-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Friday, July 16, 2004 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Previous Operation not Complete
That's it. How do you do with Report Builder? Can you share the idea?
Thanks,
Start with the JobOper table.
Filter for operations with labor or qty > 0. (Active Stuff)
Create a calculated called CurrentOper = JobOper.JobNumber +
String(JobOper.OprSeq,'9999')
Sort and Group on this field.
Add a Group Footer line on your report for this group.
Add the fields for Job, Oper, Sequence, WC, etc... On this
row.
Create an alias table join from JobOper to JobOper calling it
JobOper2.
Use the company and job fields.
Add a filter for JobOper.OprSeq > JobOper.OperSeq2.
(No you get just the prior operations)
Add JobOper2 fields to the record row such as OperSeq, WC,
operation comlete.
(Make sure record lines have JobOper2 fields not
JobOper)
Print Preview
The report should show an operation sequence on the group footer line
And all the prior operations listed above it on the record lines that print.
Now use the previous command in a calcualted field.
PriorComplete = PREVIOUS(JobOper2.OperationComplete)
This should get you pretty close.
Also when the report works just turn off printing record lines and all you
get are the
Group footer lines which are the exceptions your looking for.
Patrick Winter
-----Original Message-----
From: progress92000 [mailto:nvong@...]
Sent: Friday, July 16, 2004 10:50 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Previous Operation not Complete
That's it. How do you do with Report Builder? Can you share the idea?
Thanks,
--- In vantage@yahoogroups.com, "jzabilka" <jzabilka@t...> wrote:
> Our Priority Dispatch first groups by Jobs with previous operation
> completed, then Previous operation started but not complete, then jobs
> not started. These are all subgroups from each machine.
> Is this what you are looking for?
>
> --- In vantage@yahoogroups.com, "Judith Wayne" <wayne@d...> wrote:
> > You are too funny! I chuckled at your response!
> >
> > -----Original Message-----
> > From: Edward F. Fox, Jr. [mailto:efox@m...]
> > Sent: Friday, July 16, 2004 10:39 AM
> > To: vantage@yahoogroups.com
> > Subject: RE: [Vantage] Previous Operation not Complete
> >
> > Intimidation.
> >
> > -----Original Message-----
> > From: progress92000 [mailto:nvong@m...]
> > Sent: Friday, July 16, 2004 10:33 AM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Previous Operation not Complete
> >
> >
> > Hi,
> >
> > Can anyone tell me how to prvnet the job operation start if the
> > previous operation not complete or started?
> >
> > Any report simlilar to dispacth report with showing the previous
> > operation uncompleted by Report Builder?
> >
> > I tried but !!!
> >
> > Thanks,
> >
> >
> >
> >
> >
> > 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/.
> > <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
> > Yahoo! Groups Links
> >
> >
> >
> >
> >
> >
> >
> >
> > 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/.
> > <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
> >
> >
> >
> >
> > Yahoo! Groups Sponsor
> > ADVERTISEMENT
> > click here
> >
>
<http://us.ard.yahoo.com/SIG=129n5lp0f/M=295196.4901138.6071305.300117
> 6/
> >
>
D=groups/S=1705007183:HM/EXP=1090075120/A=2128215/R=0/SIG=10se96mf6/*h
> tt
> > p:/companion.yahoo.com>
> >
> > <http://us.adserver.yahoo.com/l?
> M=295196.4901138.6071305.3001176/D=group
> > s/S=:HM/A=2128215/rand=543604064>
> >
> > _____
> >
> > Yahoo! Groups Links
> > * To visit your group on the web, go to:
> > http://groups.yahoo.com/group/vantage/
> >
> > * To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@yahoogroups.com
> > <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
> >
> > * Your use of Yahoo! Groups is subject to the Yahoo! Terms
of
> > Service <http://docs.yahoo.com/info/terms/> .
> >
> >
> > [Non-text portions of this message have been removed]
------------------------ Yahoo! Groups Sponsor --------------------~-->
Yahoo! Domains - Claim yours for only $14.70
http://us.click.yahoo.com/Z1wmxD/DREIAA/yQLSAA/PhFolB/TM
--------------------------------------------------------------------~->
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
Yahoo! Groups Links