Open jobs report

Lydia:
Been there, done that. Anyways guys, hold the phone. Jerry Boyle at Sipco
sent me just what I needed. I'm a hero now. Thanks again, Jerry.

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com


-----Original Message-----
From: Lydia Coffman [mailto:lcoffman@...]
Sent: Friday, October 06, 2000 11:26 AM
To: vantage@egroups.com
Subject: RE: [Vantage] open jobs report

Before you knock yourself out, have you looked at the job status report?
Maybe you need something that isn't on it---just thinking.

Lydia



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, October 06, 2000 8:23 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] open jobs report

I have something like this but I would need to polish it up a bit since it
is brand new and still evolving. But the link from job to customer is via
JobProd----OrderHed----Customer. I always start any job related reports
with JobProd as the master table in case I will need to get order related
info. If I can figure out how to extract just one report and not have to
send the whole .PRL library I will send what I have to you, otherwise I
might create a new .PRL with just the one report saved in it.
-Todd C.
Harvey Vogel Mfg. Co.

-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Friday, October 06, 2000 7:15 AM
To: vantage@egroups.com
Subject: [Vantage] open jobs report


I'm looking for a simple report showing what jobs I have open in my shop
that will also show me what the customer id is for those jobs. Didn't see
one on eqroups. If anyone has such a thing, you may email it to me offlist.
If not, what join(s) do I use to tie the customer id to the job?

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




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



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)


We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)
I'm looking for a simple report showing what jobs I have open in my shop
that will also show me what the customer id is for those jobs. Didn't see
one on eqroups. If anyone has such a thing, you may email it to me offlist.
If not, what join(s) do I use to tie the customer id to the job?

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com
I have something like this but I would need to polish it up a bit since it
is brand new and still evolving. But the link from job to customer is via
JobProd----OrderHed----Customer. I always start any job related reports
with JobProd as the master table in case I will need to get order related
info. If I can figure out how to extract just one report and not have to
send the whole .PRL library I will send what I have to you, otherwise I
might create a new .PRL with just the one report saved in it.
-Todd C.
Harvey Vogel Mfg. Co.

-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Friday, October 06, 2000 7:15 AM
To: vantage@egroups.com
Subject: [Vantage] open jobs report


I'm looking for a simple report showing what jobs I have open in my shop
that will also show me what the customer id is for those jobs. Didn't see
one on eqroups. If anyone has such a thing, you may email it to me offlist.
If not, what join(s) do I use to tie the customer id to the job?

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




[Non-text portions of this message have been removed]
Before you knock yourself out, have you looked at the job status report?
Maybe you need something that isn't on it---just thinking.

Lydia



-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Friday, October 06, 2000 8:23 AM
To: 'vantage@egroups.com'
Subject: RE: [Vantage] open jobs report

I have something like this but I would need to polish it up a bit since it
is brand new and still evolving. But the link from job to customer is via
JobProd----OrderHed----Customer. I always start any job related reports
with JobProd as the master table in case I will need to get order related
info. If I can figure out how to extract just one report and not have to
send the whole .PRL library I will send what I have to you, otherwise I
might create a new .PRL with just the one report saved in it.
-Todd C.
Harvey Vogel Mfg. Co.

-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Friday, October 06, 2000 7:15 AM
To: vantage@egroups.com
Subject: [Vantage] open jobs report


I'm looking for a simple report showing what jobs I have open in my shop
that will also show me what the customer id is for those jobs. Didn't see
one on eqroups. If anyone has such a thing, you may email it to me offlist.
If not, what join(s) do I use to tie the customer id to the job?

TIA

Terry L. Williams I.S. Manager Chipsco, Inc. 993 Liberty St. Ext.
Meadville, PA 16335 814-333-6331 x236 fax: 814-337-2548 tlw@...
www.chipsco.com



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
<http://www.egroups.com/files/vantage/>
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)




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



We no longer allow attachments to files. To access/share Report Files,
please go to the following link: http://www.egroups.com/files/vantage/
(Note: If this link does not work for you the first time you try it, go to
www.egroups.com, login and be sure to save your password, choose My Groups,
choose Vantage, then choose Files. If you save the password, the link above
will work the next time you try it.)