And what where you thinking, or did I miss something?
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Frank Zeigafuse
Sent: Monday, May 15, 2006 3:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Priority Dispatch Report, 8.0
What I was thinking of would work.
Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
Of Norman Hutchins
Sent: Monday, May 15, 2006 1:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Priority Dispatch Report, 8.0
I want to grouped by opdesc so that we can pass out part of the
report to different departments. What I am looking for is a
list of jobs with the current operation ready for work for each
job.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
Of Frank Zeigafuse
Sent: Friday, May 12, 2006 4:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Priority Dispatch Report, 8.0
Do you want this grouped by opdesc or job number??
Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
Of howelllabs
Sent: Friday, May 12, 2006 4:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch Report, 8.0
Our manufacturing manager has ask me to make a Crystal report
that is
similarly to the Priority Dispatch Report, but without some of
the
information on it.
I started by using the JobHead, JobOper, and JobOpDtl tables. I
have
selected just records where JobHead.JobReleased is true and
JobHead.JobComplete is false. Grouped by JobOper.OpDesc and
sorted by
due date. So this get all active job which have a OperSeq for a
given
resource, which is a great start but I now need to filter out
that
records where the pervious Operation has not been completed I'm
at a
lost on how to do that, anyone have any ideas or a similar report
that
does this?
Thanks,
Norman Hutchins
Howell Laboratories, Inc.
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/>
<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/>
<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
SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Ma
mortgage+software&w4=Pda+database+software&w5=Database+management
+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819U
OUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software
abase+mortgage+software&w4=Pda+database+software&w5=Database+mana
gement+software&w6=Database+marketing+software&c=6&s=188&.sig=N5B
Gdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w
ase+mortgage+software&w4=Pda+database+software&w5=Database+manage
ment+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcS
QnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Man
ortgage+software&w4=Pda+database+software&w5=Database+management+
software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQ
fsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software
abase+mortgage+software&w4=Pda+database+software&w5=Database+mana
gement+software&w6=Database+marketing+software&c=6&s=188&.sig=R3C
F3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&
base+mortgage+software&w4=Pda+database+software&w5=Database+manag
ement+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBk
RUiBtvHI1u5dkymDcw> marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
_____
Message transport security by <http://www.gatewaydefender.com>
GatewayDefender
4:51:39 PM ET - 5/12/2006
[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/.
<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 LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
_____
Message transport security by <http://www.gatewaydefender.com>
GatewayDefender
3:26:46 PM ET - 5/15/2006
[Non-text portions of this message have been removed]
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of Frank Zeigafuse
Sent: Monday, May 15, 2006 3:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Priority Dispatch Report, 8.0
What I was thinking of would work.
Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
Of Norman Hutchins
Sent: Monday, May 15, 2006 1:27 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Priority Dispatch Report, 8.0
I want to grouped by opdesc so that we can pass out part of the
report to different departments. What I am looking for is a
list of jobs with the current operation ready for work for each
job.
_____
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
Of Frank Zeigafuse
Sent: Friday, May 12, 2006 4:52 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Priority Dispatch Report, 8.0
Do you want this grouped by opdesc or job number??
Innovative Office Products, Inc.
Frank Zeigafuse
General Manager
610-559-6369
fzeigafuse@...
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf
Of howelllabs
Sent: Friday, May 12, 2006 4:04 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch Report, 8.0
Our manufacturing manager has ask me to make a Crystal report
that is
similarly to the Priority Dispatch Report, but without some of
the
information on it.
I started by using the JobHead, JobOper, and JobOpDtl tables. I
have
selected just records where JobHead.JobReleased is true and
JobHead.JobComplete is false. Grouped by JobOper.OpDesc and
sorted by
due date. So this get all active job which have a OperSeq for a
given
resource, which is a great start but I now need to filter out
that
records where the pervious Operation has not been completed I'm
at a
lost on how to do that, anyone have any ideas or a similar report
that
does this?
Thanks,
Norman Hutchins
Howell Laboratories, Inc.
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/>
<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/>
<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
SPONSORED LINKS
Manufacturing
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Ma
> &k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+
mortgage+software&w4=Pda+database+software&w5=Database+management
+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819U
OUOg63i0bu6kA> software
Membership
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Membership+database+software
> &k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Dat
abase+mortgage+software&w4=Pda+database+software&w5=Database+mana
gement+software&w6=Database+marketing+software&c=6&s=188&.sig=N5B
Gdur84p-jyuOomcQdbQ> database software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w
> &k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Datab
ase+mortgage+software&w4=Pda+database+software&w5=Database+manage
ment+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcS
QnCqJhTCZu-0Si39A> mortgage software
Pda
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Man
> &k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+m
ortgage+software&w4=Pda+database+software&w5=Database+management+
software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQ
fsWIT39aHDkg> database software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+management+software
> &k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Dat
abase+mortgage+software&w4=Pda+database+software&w5=Database+mana
gement+software&w6=Database+marketing+software&c=6&s=188&.sig=R3C
F3ODPY4gwjDZjykQYvw> management software
Database
<http://groups.yahoo.com/gads?t=ms
<http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&
> &k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Data
base+mortgage+software&w4=Pda+database+software&w5=Database+manag
ement+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBk
RUiBtvHI1u5dkymDcw> marketing software
_____
YAHOO! GROUPS LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
_____
Message transport security by <http://www.gatewaydefender.com>
GatewayDefender
4:51:39 PM ET - 5/12/2006
[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/.
<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 LINKS
* Visit your group "vantage
<http://groups.yahoo.com/group/vantage> " on the web.
* 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!
<http://docs.yahoo.com/info/terms/> Terms of Service.
_____
_____
Message transport security by <http://www.gatewaydefender.com>
GatewayDefender
3:26:46 PM ET - 5/15/2006
[Non-text portions of this message have been removed]