I would do this:
for each JobHead where ( JobHead.JobReleased = True AND JobHead.JobComplete = False) no-lock , first JobOper where ( JobOper.OpComplete = False) and (JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum) no-lock , last LaborDtl outer-join where (JobOper.Company = LaborDtl.Company and JobOper.JobNum = LaborDtl.JobNum and JobOper.AssemblySeq = LaborDtl.AssemblySeq and JobOper.OprSeq = LaborDtl.OprSeq) no-lock , each EmpBasic outer-join where (LaborDtl.Company = EmpBasic.Company and LaborDtl.EmployeeNum = EmpBasic.EmpID) no-lock .
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, February 09, 2011 7:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ for JobDtl
Hi all
Im trying to write a BAQ which will show a Job Number and show the currect
operation.
Example:
If a job XYZ for part ABC has 3 operations - Pickup > Move > Put Down
Pickup has been complete, so an operator is working on 'Move'.
Move many have been partially completed but not ticked as 'Complete'.
I dont want to see 'Put Down' becasue that isnt started yet.
I only want to be able to see the following ...
Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)
XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â MOVEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â B. Clinton
Then when MOVE has been complete, the next time I run the BAQ it would be as
follows ...
Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)
XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â Â Â Â PUT DOWNÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â G. Bush
So far, I have it so it shows ALL operations that havent been complete, but I'm
just interested in the CURRENT operation.
Any help would be greatly appreciated.
Thanks.
[Non-text portions of this message have been removed]
------------------------------------
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/linksYahoo! Groups Links
for each JobHead where ( JobHead.JobReleased = True AND JobHead.JobComplete = False) no-lock , first JobOper where ( JobOper.OpComplete = False) and (JobHead.Company = JobOper.Company and JobHead.JobNum = JobOper.JobNum) no-lock , last LaborDtl outer-join where (JobOper.Company = LaborDtl.Company and JobOper.JobNum = LaborDtl.JobNum and JobOper.AssemblySeq = LaborDtl.AssemblySeq and JobOper.OprSeq = LaborDtl.OprSeq) no-lock , each EmpBasic outer-join where (LaborDtl.Company = EmpBasic.Company and LaborDtl.EmployeeNum = EmpBasic.EmpID) no-lock .
-bws
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Chris Thompson
Sent: Wednesday, February 09, 2011 7:00 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Vantage - BAQ for JobDtl
Hi all
Im trying to write a BAQ which will show a Job Number and show the currect
operation.
Example:
If a job XYZ for part ABC has 3 operations - Pickup > Move > Put Down
Pickup has been complete, so an operator is working on 'Move'.
Move many have been partially completed but not ticked as 'Complete'.
I dont want to see 'Put Down' becasue that isnt started yet.
I only want to be able to see the following ...
Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)
XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â MOVEÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â Â B. Clinton
Then when MOVE has been complete, the next time I run the BAQ it would be as
follows ...
Job Number      Part         Current Operation      Operator (not
essential but would be nice to have)
XYZÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â ABCÂ Â Â Â Â Â Â Â Â Â Â Â PUT DOWNÂ Â Â Â Â Â Â Â Â Â Â Â Â Â Â G. Bush
So far, I have it so it shows ALL operations that havent been complete, but I'm
just interested in the CURRENT operation.
Any help would be greatly appreciated.
Thanks.
[Non-text portions of this message have been removed]
------------------------------------
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/linksYahoo! Groups Links