Job status reporting

Yahoo Archive
1
Your welcome.

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
cmulford_66
Sent: Monday, January 30, 2006 1:17 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job status reporting


--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
Thanks Frank,

That got me a lot closer!

Thanks again,
Chris

> Try this
>
> Group on job number
> Filter out complete operations
>
> Sort by seq number
> Do a summarize function on the seq number to find the min for group
part
> number
>
> Below is pseudo code
>
> Then in the detail section do this
> if seq <> group min
> then default attribute
>
> Also mark to hide the detail section
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@l...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> cmulford_66
> Sent: Thursday, January 26, 2006 3:40 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Job status reporting
>
>
> We need to know only the operation/wc that a job is at when the
> report is run , not all the incomplete ops. Op 30 in the example
> below. Currently we have to report 30 through 60.
>
>
> 10 = complete
> 20 = complete
> 30 = 1/3 complete
> 40 =
> 50 =
> 60 =
>
>
> Chris
>
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
> wrote:
> >
> > What do you mean by current?
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@l...
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > cmulford_66
> > Sent: Thursday, January 26, 2006 2:39 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Job status reporting
> >
> >
> > Has anyone been able to come up with a way to report only the
> current
> > operation using Crystal on Vantage 6.1? Our number of jobs can run
> into
> > the 1000s and a report that show 'op complete = false' is too
large
> to
> > get any useable data from it. I only need to show the current or
> > possibly the next op. Also, Our op sequences are not consistant.
> >
> > Thanks,
> > Chris
> >
> >
> >
> >
> >
> >
> > 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
> >
>
>
>
>
>
>
>
> 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
>






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
2
Has anyone been able to come up with a way to report only the current
operation using Crystal on Vantage 6.1? Our number of jobs can run into
the 1000s and a report that show 'op complete = false' is too large to
get any useable data from it. I only need to show the current or
possibly the next op. Also, Our op sequences are not consistant.

Thanks,
Chris
3
We have a report we call the Last Scan Report. Basically
this tells us which op and date it was clocked onto.

We use the ClockInMinute field off of the Labor detail table
to tells us this.

HTH,

M. Manasa Reddy
ERP Systems Specialist
Crestview Aerospace Corporation
Email: mmreddy@...
Phone: (850) 682-2746 x 272


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of cmulford_66
Sent: Thursday, January 26, 2006 1:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job status reporting


Has anyone been able to come up with a way to report only
the current
operation using Crystal on Vantage 6.1? Our number of jobs
can run into
the 1000s and a report that show 'op complete = false' is
too large to
get any useable data from it. I only need to show the
current or
possibly the next op. Also, Our op sequences are not
consistant.

Thanks,
Chris






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



SPONSORED LINKS Manufacturing software Membership
database software Database mortgage software
Pda database software Database management software
Database marketing software


------------------------------------------------------------
------------------
YAHOO! GROUPS LINKS

a.. Visit your group "vantage" on the web.

b.. To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com

c.. Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service.


------------------------------------------------------------
------------------



[Non-text portions of this message have been removed]
4
What do you mean by current?

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
cmulford_66
Sent: Thursday, January 26, 2006 2:39 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Job status reporting


Has anyone been able to come up with a way to report only the current
operation using Crystal on Vantage 6.1? Our number of jobs can run into
the 1000s and a report that show 'op complete = false' is too large to
get any useable data from it. I only need to show the current or
possibly the next op. Also, Our op sequences are not consistant.

Thanks,
Chris






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
5
We need to know only the operation/wc that a job is at when the
report is run , not all the incomplete ops. Op 30 in the example
below. Currently we have to report 30 through 60.


10 = complete
20 = complete
30 = 1/3 complete
40 =
50 =
60 =


Chris






--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
> What do you mean by current?
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@l...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> cmulford_66
> Sent: Thursday, January 26, 2006 2:39 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job status reporting
>
>
> Has anyone been able to come up with a way to report only the
current
> operation using Crystal on Vantage 6.1? Our number of jobs can run
into
> the 1000s and a report that show 'op complete = false' is too large
to
> get any useable data from it. I only need to show the current or
> possibly the next op. Also, Our op sequences are not consistant.
>
> Thanks,
> Chris
>
>
>
>
>
>
> 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
>
6
Try this

Group on job number
Filter out complete operations

Sort by seq number
Do a summarize function on the seq number to find the min for group part
number

Below is pseudo code

Then in the detail section do this
if seq <> group min
then default attribute

Also mark to hide the detail section

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
cmulford_66
Sent: Thursday, January 26, 2006 3:40 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Job status reporting


We need to know only the operation/wc that a job is at when the
report is run , not all the incomplete ops. Op 30 in the example
below. Currently we have to report 30 through 60.


10 = complete
20 = complete
30 = 1/3 complete
40 =
50 =
60 =


Chris






--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
> What do you mean by current?
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@l...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> cmulford_66
> Sent: Thursday, January 26, 2006 2:39 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Job status reporting
>
>
> Has anyone been able to come up with a way to report only the
current
> operation using Crystal on Vantage 6.1? Our number of jobs can run
into
> the 1000s and a report that show 'op complete = false' is too large
to
> get any useable data from it. I only need to show the current or
> possibly the next op. Also, Our op sequences are not consistant.
>
> Thanks,
> Chris
>
>
>
>
>
>
> 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
>







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
7
--- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
wrote:
>
Thanks Frank,

That got me a lot closer!

Thanks again,
Chris

> Try this
>
> Group on job number
> Filter out complete operations
>
> Sort by seq number
> Do a summarize function on the seq number to find the min for group
part
> number
>
> Below is pseudo code
>
> Then in the detail section do this
> if seq <> group min
> then default attribute
>
> Also mark to hide the detail section
>
> Innovative Office Products, Inc.
> Frank Zeigafuse
> General Manager
> 610-559-6369
> fzeigafuse@l...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> cmulford_66
> Sent: Thursday, January 26, 2006 3:40 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Job status reporting
>
>
> We need to know only the operation/wc that a job is at when the
> report is run , not all the incomplete ops. Op 30 in the example
> below. Currently we have to report 30 through 60.
>
>
> 10 = complete
> 20 = complete
> 30 = 1/3 complete
> 40 =
> 50 =
> 60 =
>
>
> Chris
>
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Frank Zeigafuse" <fzeigafuse@l...>
> wrote:
> >
> > What do you mean by current?
> >
> > Innovative Office Products, Inc.
> > Frank Zeigafuse
> > General Manager
> > 610-559-6369
> > fzeigafuse@l...
> >
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > cmulford_66
> > Sent: Thursday, January 26, 2006 2:39 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Job status reporting
> >
> >
> > Has anyone been able to come up with a way to report only the
> current
> > operation using Crystal on Vantage 6.1? Our number of jobs can run
> into
> > the 1000s and a report that show 'op complete = false' is too
large
> to
> > get any useable data from it. I only need to show the current or
> > possibly the next op. Also, Our op sequences are not consistant.
> >
> > Thanks,
> > Chris
> >
> >
> >
> >
> >
> >
> > 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
> >
>
>
>
>
>
>
>
> 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
>