I can't tell you why its doing that but if you have Access 2000 and want to
use a customer PDR then you can download ours at
http://www.ktcorp.com/vantage/PDR/
Steps
Download the file
Rename the file exention to .MDB
Relink your tables via odbc
Run the report.

Good luck
Jeremy Leonard
IT Manager
K-T Corporation

-----Original Message-----
From: Janet Memmelaar [mailto:janet@...]
Sent: Monday, July 21, 2003 9:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch Report

Hi Everyone,

Does anyone know why in the Priority Dispatch Report Sequences that are not
complete for Jobs that have been closed show up on this report ?

Is there a place where I can check a box to have them omitted ?

Thanks

Janet Memmelaar
Vice-President Information Systems
Metal Cutting Corporation
89 Commerce Road
Cedar Grove, NJ 07009 USA
1-800-783-6382
1-973-239-1100 x28
Fax 1-973-239-6651
www.metalcutting.com

[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/links

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

You can create this report with report builder which would give you control
over such issues. The standard report you are stuck with.

Patrick

-----Original Message-----
From: Janet Memmelaar [mailto:janet@...]
Sent: Monday, July 21, 2003 9:49 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch Report

Hi Everyone,

Does anyone know why in the Priority Dispatch Report Sequences that are not
complete for Jobs that have been closed show up on this report ?

Is there a place where I can check a box to have them omitted ?

Thanks

Janet Memmelaar
Vice-President Information Systems
Metal Cutting Corporation
89 Commerce Road
Cedar Grove, NJ 07009 USA
1-800-783-6382
1-973-239-1100 x28
Fax 1-973-239-6651
www.metalcutting.com

[Non-text portions of this message have been removed]

------------------------ Yahoo! Groups Sponsor ---------------------~--> Buy
Ink Cartridges or Refill Kits for Your HP, Epson, Canon or Lexmark Printer
at Myinks.com. Free s/h on orders $50 or more to the US & Canada.
http://www.c1tracking.com/l.asp?cid=5511
http://us.click.yahoo.com/sOykFB/k9VGAA/ySSFAA/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

Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

Hi,

Can I have a copy please?

Thanks,

--- In vantage@yahoogroups.com, "Leonard, Jeremy" <jleonard@k...>
wrote:

> I can't tell you why its doing that but if you have Access 2000 and

want to

> use a customer PDR then you can download ours at
> http://www.ktcorp.com/vantage/PDR/
> Steps
> Download the file
> Rename the file exention to .MDB
> Relink your tables via odbc
> Run the report.
>
> Good luck
> Jeremy Leonard
> IT Manager
> K-T Corporation
>
>
> -----Original Message-----
> From: Janet Memmelaar [mailto:janet@m...]
> Sent: Monday, July 21, 2003 9:49 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Priority Dispatch Report
>
>
> Hi Everyone,
>
> Does anyone know why in the Priority Dispatch Report Sequences that

are not

> complete for Jobs that have been closed show up on this report ?
>
> Is there a place where I can check a box to have them omitted ?
>
> Thanks
>
> Janet Memmelaar
> Vice-President Information Systems
> Metal Cutting Corporation
> 89 Commerce Road
> Cedar Grove, NJ 07009 USA
> 1-800-783-6382
> 1-973-239-1100 x28
> Fax 1-973-239-6651
> www.metalcutting.com
>
>
> [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/links
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/

It's not easy but here is one way:
Alias join JobOper2 to JobOper.
Filter for only sequences greater such as JobOper2.OperSeq > JobOper.OperSeq
Use the Aggregate Minimum on the JobOper2.OperSeq to show then Next
Operation and workcenter.
You can also use the PREVIOUS command to read the prior record, if sorted
properly you get the work center you want

Good Luck.

Patrick Winter

-----Original Message-----
From: Amy Creighton [mailto:acreighton@...]
Sent: Wednesday, March 17, 2004 8:12 AM
To: 'Egroup'
Subject: [Vantage] Priority Dispatch Report

Has anyone re-written the Priority Dispatch report in Report Builder? I
need to know how to get the "NEXT WC" field. Thank you.

Amy

Amy T. Creighton
Operations Manager
Parkinson Technologies
acreighton@...
(p) 401-762-2100 x 324
(f) 401-762-2295

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

Current = Prior Operation is complete.
Available = Prior Operation is started but not complete.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ace_Man
Sent: Thursday, March 09, 2006 10:14 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Priority Dispatch Report

Any of you out there that had to re-create this report yet? I'm re creating
this report for my company to add some fields. I pretty much have most of
everything put together except for the "region" part of the report.
Regions:
***CURRENT WORK
***AVAILABLE WORK
***EXPECTED WORK
I was wondering what field(s) are these regions' logic coming from.

Thanks in advance.

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

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

I guess I should have been more specific; I am re-writing this in CR
8.5 and was wondering how would I go about doing that. I can see
what the report is doing by comparing the report to the Job Tracker.
Does a field exist in Vantage 6.10.533 that would tell me the prior
operation for that particular Job or is it coded through the report?

--- In vantage@yahoogroups.com, pjw@... wrote:
>
> Current = Prior Operation is complete.
> Available = Prior Operation is started but not complete.
>
>
> Patrick Winter
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ace_Man
> Sent: Thursday, March 09, 2006 10:14 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Priority Dispatch Report
>
> Any of you out there that had to re-create this report yet? I'm re
creating
> this report for my company to add some fields. I pretty much have
most of
> everything put together except for the "region" part of the report.
> Regions:
> ***CURRENT WORK
> ***AVAILABLE WORK
> ***EXPECTED WORK
> I was wondering what field(s) are these regions' logic coming from.
>
> Thanks in advance.
>

The only way I have been able to figure out how to read prior or subsequent
operations with crystal or report builder is an alias table join to joboper
again calling it JobOper2 joining just using the company and job so it lists
all operations. Then filtering for JobOper seq > JobOper2 seq gives you the
prior. I have not tried this in crystal but you can do greater than or less
than joins which may remove the need for the filter.

Good Luck.

Patrick
-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ace_Man
Sent: Thursday, March 09, 2006 1:06 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Priority Dispatch Report

I guess I should have been more specific; I am re-writing this in CR
8.5 and was wondering how would I go about doing that. I can see what the
report is doing by comparing the report to the Job Tracker.
Does a field exist in Vantage 6.10.533 that would tell me the prior
operation for that particular Job or is it coded through the report?

--- In vantage@yahoogroups.com, pjw@... wrote:
>
> Current = Prior Operation is complete.
> Available = Prior Operation is started but not complete.
>
>
> Patrick Winter
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ace_Man
> Sent: Thursday, March 09, 2006 10:14 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Priority Dispatch Report
>
> Any of you out there that had to re-create this report yet? I'm re
creating
> this report for my company to add some fields. I pretty much have
most of
> everything put together except for the "region" part of the report.
> Regions:
> ***CURRENT WORK
> ***AVAILABLE WORK
> ***EXPECTED WORK
> I was wondering what field(s) are these regions' logic coming from.
>
> Thanks in advance.
>

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

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

Well, That didn't work. It just gave me repeated data where each
job's opseq are multiplied by how many sequence from the JobOper to
the JobOper2 table. Anyone else want to take a crack at how the
regions from this report are taken from the tables using Crystal
Reports?

--- In vantage@yahoogroups.com, pjw@... wrote:
>
> The only way I have been able to figure out how to read prior or
subsequent
> operations with crystal or report builder is an alias table join
to joboper
> again calling it JobOper2 joining just using the company and job
so it lists
> all operations. Then filtering for JobOper seq > JobOper2 seq
gives you the
> prior. I have not tried this in crystal but you can do greater
than or less
> than joins which may remove the need for the filter.
>
> Good Luck.
>
> Patrick

Hi,

Try this, I haven't tried it but it is just my thoughts, you will
need to setup variables to pass between the two reports.

My general thoughts are so.

1)Create the two reports as below, if you don't use multiple
assemblies.
2)Create the necessary parameters to pass the relevant op code into
the filter of the sub-report.
3) In the sub report, create a group on Joboper.jobnum and maybe the
assembly table as well.
4) In the sub report filter on the opr seq as below.
5) In the sub report group footer section add the revelant fields,
qty complete, op complete etc. You will see the footer contains the
last entry.
6) Create the necesary formula fields to determine regions. place
these in the footer
7) Create the necessary variables to pass back the values of the
formulas back to the main report.
8) In the main report suppress the sub-report section, not sure if
this will work. Match up the variables to formulas.

By the way, if you are interested, corvu has this all built in.

I hope this helps.

--- In vantage@yahoogroups.com, "Ace_Man" <ace_man@...> wrote:
>
> Well, That didn't work. It just gave me repeated data where each
> job's opseq are multiplied by how many sequence from the JobOper
to
> the JobOper2 table. Anyone else want to take a crack at how the
> regions from this report are taken from the tables using Crystal
> Reports?
>
> --- In vantage@yahoogroups.com, pjw@ wrote:
> >
> > The only way I have been able to figure out how to read prior or
> subsequent
> > operations with crystal or report builder is an alias table join
> to joboper
> > again calling it JobOper2 joining just using the company and job
> so it lists
> > all operations. Then filtering for JobOper seq > JobOper2 seq
> gives you the
> > prior. I have not tried this in crystal but you can do greater
> than or less
> > than joins which may remove the need for the filter.
> >
> > Good Luck.
> >
> > Patrick
>

Ace_Man,

Hang on a minute. That's exactly what's suppose to happen.

"It just gave me repeated data where each job's oprseq are multiplied by how
many sequence from the JobOper to the JobOper2 table."

JobOper 040 --- JobOper 010
JobOper 040 --- JobOper 020
JobOper 040 --- JobOper 030
JobOper 040 --- JobOper 040
JobOper 040 --- JobOper 050

Filter for JobOper > JobOper2

JobOper 040 --- Job Oper 010
JobOper 040 --- Job Oper 020
JobOper 040 --- Job Oper 030

Now sort and group on the JobOper. Print the jobOper on the Group Footer
record.

JobOper 040 --- Job Oper 010
JobOper 040 --- Job Oper 020
JobOper 040 --- Job Oper 030
JobOper 040 --- Job Oper 030 -- Group Footer Line.

Now turn off record lines from printing.
Your left with the operation and the prior operation.

JobOper 040 --- Job Oper 030 -- Group Footer Line.

Patrick Winter

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ace_Man
Sent: Monday, March 13, 2006 8:17 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Priority Dispatch Report

Well, That didn't work. It just gave me repeated data where each job's opseq
are multiplied by how many sequence from the JobOper to the JobOper2 table.
Anyone else want to take a crack at how the regions from this report are
taken from the tables using Crystal Reports?

--- In vantage@yahoogroups.com, pjw@... wrote:
>
> The only way I have been able to figure out how to read prior or
subsequent
> operations with crystal or report builder is an alias table join
to joboper
> again calling it JobOper2 joining just using the company and job
so it lists
> all operations. Then filtering for JobOper seq > JobOper2 seq
gives you the
> prior. I have not tried this in crystal but you can do greater
than or less
> than joins which may remove the need for the filter.
>
> Good Luck.
>
> Patrick

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

This e-mail and any attachments may contain confidential and
privileged information. If you are not the intended recipient,
please notify the sender immediately by return e-mail, delete this
e-mail and destroy any copies. Any dissemination or use of this
information by a person other than the intended recipient is
unauthorized and may be illegal.

Alot better than my soultion....

--- In vantage@yahoogroups.com, pjw@... wrote:
>
> Ace_Man,
>
> Hang on a minute. That's exactly what's suppose to happen.
>
> "It just gave me repeated data where each job's oprseq are
multiplied by how
> many sequence from the JobOper to the JobOper2 table."
>
> JobOper 040 --- JobOper 010
> JobOper 040 --- JobOper 020
> JobOper 040 --- JobOper 030
> JobOper 040 --- JobOper 040
> JobOper 040 --- JobOper 050
>
> Filter for JobOper > JobOper2
>
> JobOper 040 --- Job Oper 010
> JobOper 040 --- Job Oper 020
> JobOper 040 --- Job Oper 030
>
> Now sort and group on the JobOper. Print the jobOper on the Group
Footer
> record.
>
> JobOper 040 --- Job Oper 010
> JobOper 040 --- Job Oper 020
> JobOper 040 --- Job Oper 030
> JobOper 040 --- Job Oper 030 -- Group Footer Line.
>
> Now turn off record lines from printing.
> Your left with the operation and the prior operation.
>
> JobOper 040 --- Job Oper 030 -- Group Footer Line.
>
>
> Patrick Winter
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ace_Man
> Sent: Monday, March 13, 2006 8:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Priority Dispatch Report
>
> Well, That didn't work. It just gave me repeated data where each
job's opseq
> are multiplied by how many sequence from the JobOper to the
JobOper2 table.
> Anyone else want to take a crack at how the regions from this
report are
> taken from the tables using Crystal Reports?
>
> --- In vantage@yahoogroups.com, pjw@ wrote:
> >
> > The only way I have been able to figure out how to read prior or
> subsequent
> > operations with crystal or report builder is an alias table join
> to joboper
> > again calling it JobOper2 joining just using the company and job
> so it lists
> > all operations. Then filtering for JobOper seq > JobOper2 seq
> gives you the
> > prior. I have not tried this in crystal but you can do greater
> than or less
> > than joins which may remove the need for the filter.
> >
> > Good Luck.
> >
> > Patrick
>
>
>
>
>
>
> 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
>
>
>
>
>
>
> This e-mail and any attachments may contain confidential and
> privileged information. If you are not the intended recipient,
> please notify the sender immediately by return e-mail, delete this
> e-mail and destroy any copies. Any dissemination or use of this
> information by a person other than the intended recipient is
> unauthorized and may be illegal.
>

Yep, that's what I was getting. I didn't think about using the
footer. Thanks, I'll give that a try.

--- In vantage@yahoogroups.com, pjw@... wrote:
>
> Ace_Man,
>
> Hang on a minute. That's exactly what's suppose to happen.
>
> "It just gave me repeated data where each job's oprseq are
multiplied by how
> many sequence from the JobOper to the JobOper2 table."
>
> JobOper 040 --- JobOper 010
> JobOper 040 --- JobOper 020
> JobOper 040 --- JobOper 030
> JobOper 040 --- JobOper 040
> JobOper 040 --- JobOper 050
>
> Filter for JobOper > JobOper2
>
> JobOper 040 --- Job Oper 010
> JobOper 040 --- Job Oper 020
> JobOper 040 --- Job Oper 030
>
> Now sort and group on the JobOper. Print the jobOper on the Group
Footer
> record.
>
> JobOper 040 --- Job Oper 010
> JobOper 040 --- Job Oper 020
> JobOper 040 --- Job Oper 030
> JobOper 040 --- Job Oper 030 -- Group Footer Line.
>
> Now turn off record lines from printing.
> Your left with the operation and the prior operation.
>
> JobOper 040 --- Job Oper 030 -- Group Footer Line.
>
>
> Patrick Winter
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Ace_Man
> Sent: Monday, March 13, 2006 8:17 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Re: Priority Dispatch Report
>
> Well, That didn't work. It just gave me repeated data where each
job's opseq
> are multiplied by how many sequence from the JobOper to the
JobOper2 table.
> Anyone else want to take a crack at how the regions from this
report are
> taken from the tables using Crystal Reports?
>

That logic do sound pretty good. I'll give it a shot. Thank you!

--- In vantage@yahoogroups.com, "brychanwilliams" <brychanw@...>
wrote:

>
> Hi,
>
> Try this, I haven't tried it but it is just my thoughts, you will
> need to setup variables to pass between the two reports.
>
> My general thoughts are so.
>
> 1)Create the two reports as below, if you don't use multiple
> assemblies.
> 2)Create the necessary parameters to pass the relevant op code

into

> the filter of the sub-report.
> 3) In the sub report, create a group on Joboper.jobnum and maybe

the

> assembly table as well.
> 4) In the sub report filter on the opr seq as below.
> 5) In the sub report group footer section add the revelant fields,
> qty complete, op complete etc. You will see the footer contains

the

> last entry.
> 6) Create the necesary formula fields to determine regions. place
> these in the footer
> 7) Create the necessary variables to pass back the values of the
> formulas back to the main report.
> 8) In the main report suppress the sub-report section, not sure if
> this will work. Match up the variables to formulas.
>
>
> By the way, if you are interested, corvu has this all built in.
>
> I hope this helps.
>
>
>
>
>
>
> --- In vantage@yahoogroups.com, "Ace_Man" <ace_man@> wrote:
> >
> > Well, That didn't work. It just gave me repeated data where each
> > job's opseq are multiplied by how many sequence from the JobOper
> to
> > the JobOper2 table. Anyone else want to take a crack at how the
> > regions from this report are taken from the tables using Crystal
> > Reports?
> >