I have and will. Thank you all. Any more suggestions, feel free to send
them along.
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, August 16, 2001 1:59 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB 9.0
I have not had a problem with this because my first operation is kind of a
dummy one (Check Tooling) which doesn't get production labor reported
against it. It's easy to assume people have the system setup they way your
own company does when working with report builder. I think you could also do
an outer join and check for an unknown but outer joins tend to really slow
down report performance.
Terry, I hope you find something useful in all of this.
Patrick
-----Original Message-----
From: Todd Anderson [mailto:tanderson@...]
Sent: Thursday, August 16, 2001 11:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB 9.0
Pat,
There is one problem with this approach.
You are filtering on JobOper_Previous < JobOper to only list the previous
operations for the current operation.
When the current operation is the FIRST operation you will not see it since
there are NO previous operations.
If you specify < or = to then the filter will work but you have look at the
prev - prev record for the last info.
Todd Anderson
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, August 16, 2001 10:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB 9.0
Yes, I have done this. There may be other ways, this was my method.
How to display information about a prior operation such as qty completed, if
it's closed, etc... With report builder. Basically you are going to list all
prior operations on the record level for any given operation with record
line printing turned off.
JOINS
I did a join from JobOper to JobOper (Alias name JobOper_Previous) just on
COMPANY and JOBNUMBER so for each JobOper record I'm working on I will then
list all operations for that job.
FILTER
In the report filter I added a line JobOper_Previous < JobOper, now I just
get operations prior to the one I'm gathering data for.
VARIABLE
I created a variable which was the start date & Job combined.
Start_Job = STRING(YEAR(JobOper.StartDate),"9999") +
STRING(MONTH(JobOper.StartDate),"99") + STRING(DAY(JobOper.StartDate),"99")
+ STRING(JobOper.JobNum)
SORT & GROUP
JobOper.WCCode
Start_Job
Now your report should display all your records on the "Start_Job" group and
all prior operations on the record line. Turn off record lines.
Now JobOper_Previous.Complete will get you what you want, if the first
operation sequence is an issue create a variable to check it like
IIF(JobOper.OprSeq = 010 or JobOper_Previous.Complete,True,False)
If you want to really get crazy use the previous command on the
JobOper_Previous table to look back two operations you can do this if you
create a variable to check if your on the same job number.
Call me if you need help.
Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone or Fax: 815.969.4147
-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Thursday, August 16, 2001 8:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB 9.0
Before I go any further with this I gotta know if anyone else has done it.
I duplicated the Priority Dispatch Report and resorted it by
dept/wc/priority. I'm filtering to include only the open operations but I
also need to know what the prior workcenter was, closed or not. This is
where it gets tricky. The prior workcenter may not always be accurate
because if it was completed it's record got ignored and was not available to
the current open record showing on the report. Thus the current record
would show an incorrect prior workcenter.
I know how I could do this with the proper programming tools but since they
aren't available to me, I need to find an alternative. I created three
exports to Excel with a back-end VB macro but if it's possible in RB, I'd
like to go that route. Any thoughts?
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
www.chipsco.com
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
< 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
< http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
< http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*
http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
997975131>
<
http://us.adserver.yahoo.com/l?M=210949.1523302.3121208.1269402/D=egroupmai
l/S=1705007183:HM/A=763786/rand=883546874>
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
< 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
< http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .
[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/
Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
997984757>
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 the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]
them along.
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, August 16, 2001 1:59 PM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB 9.0
I have not had a problem with this because my first operation is kind of a
dummy one (Check Tooling) which doesn't get production labor reported
against it. It's easy to assume people have the system setup they way your
own company does when working with report builder. I think you could also do
an outer join and check for an unknown but outer joins tend to really slow
down report performance.
Terry, I hope you find something useful in all of this.
Patrick
-----Original Message-----
From: Todd Anderson [mailto:tanderson@...]
Sent: Thursday, August 16, 2001 11:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB 9.0
Pat,
There is one problem with this approach.
You are filtering on JobOper_Previous < JobOper to only list the previous
operations for the current operation.
When the current operation is the FIRST operation you will not see it since
there are NO previous operations.
If you specify < or = to then the filter will work but you have look at the
prev - prev record for the last info.
Todd Anderson
-----Original Message-----
From: Winter, Patrick [mailto:pjw@...]
Sent: Thursday, August 16, 2001 10:17 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] RB 9.0
Yes, I have done this. There may be other ways, this was my method.
How to display information about a prior operation such as qty completed, if
it's closed, etc... With report builder. Basically you are going to list all
prior operations on the record level for any given operation with record
line printing turned off.
JOINS
I did a join from JobOper to JobOper (Alias name JobOper_Previous) just on
COMPANY and JOBNUMBER so for each JobOper record I'm working on I will then
list all operations for that job.
FILTER
In the report filter I added a line JobOper_Previous < JobOper, now I just
get operations prior to the one I'm gathering data for.
VARIABLE
I created a variable which was the start date & Job combined.
Start_Job = STRING(YEAR(JobOper.StartDate),"9999") +
STRING(MONTH(JobOper.StartDate),"99") + STRING(DAY(JobOper.StartDate),"99")
+ STRING(JobOper.JobNum)
SORT & GROUP
JobOper.WCCode
Start_Job
Now your report should display all your records on the "Start_Job" group and
all prior operations on the record line. Turn off record lines.
Now JobOper_Previous.Complete will get you what you want, if the first
operation sequence is an issue create a variable to check it like
IIF(JobOper.OprSeq = 010 or JobOper_Previous.Complete,True,False)
If you want to really get crazy use the previous command on the
JobOper_Previous table to look back two operations you can do this if you
create a variable to check if your on the same job number.
Call me if you need help.
Patrick J. Winter
Information Services Manager
Specialty Screw Corporation
2801 Huffman Boulevard
Rockford IL 61103
Phone or Fax: 815.969.4147
-----Original Message-----
From: Terry Williams [mailto:tlw@...]
Sent: Thursday, August 16, 2001 8:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] RB 9.0
Before I go any further with this I gotta know if anyone else has done it.
I duplicated the Priority Dispatch Report and resorted it by
dept/wc/priority. I'm filtering to include only the open operations but I
also need to know what the prior workcenter was, closed or not. This is
where it gets tricky. The prior workcenter may not always be accurate
because if it was completed it's record got ignored and was not available to
the current open record showing on the report. Thus the current record
would show an incorrect prior workcenter.
I know how I could do this with the proper programming tools but since they
aren't available to me, I need to find an alternative. I created three
exports to Excel with a back-end VB macro but if it's possible in RB, I'd
like to go that route. Any thoughts?
Terry L. Williams I.S. Manager Chipsco, Inc. 9936 Liberty St. Ext.
Meadville, PA 16335 p.8143336331 x236 f.8143372548 tlw@...
www.chipsco.com
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
< 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
< http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
< http://docs.yahoo.com/info/terms/>
Yahoo! Groups Sponsor
<
http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*
http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
997975131>
<
http://us.adserver.yahoo.com/l?M=210949.1523302.3121208.1269402/D=egroupmai
l/S=1705007183:HM/A=763786/rand=883546874>
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
< 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
< http://groups.yahoo.com/group/vantage/links>
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
< http://docs.yahoo.com/info/terms/> .
[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/
Yahoo! Groups Sponsor
<http://rd.yahoo.com/M=210949.1523302.3121208.1269402/D=egroupweb/S=17050071
83:HM/A=763786/R=0/*http://altfarm.mediaplex.com/ad/ck/1177-4458-1039-1?mpt=
997984757>
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 the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .
[Non-text portions of this message have been removed]