Help

Yahoo Archive
1
Mike
In PET have you compared the default config of both you training and
production databases for Max Users and Max Servers. I know when I upgraded
to Version 6 I had done all the math and I would up having to call Tech
Support led me through some NEW MATH ?? to figure users and servers. I have
69 users + 12 data collection licenses. I'm set at 124 users and 56 servers.
This is like 50 % higher than the calc's by the book.

Cliff Drumeller
Information Technology Manager
Mass Precision Sheetmetal
408 954-0200 ex 217
2
I am working in Vantage 6.0 and I am having a hell of a time with the
following any help would be greatly appreciated. We are using the
scheduling module and due to priority changes some jobs will need
to be rescheduled. Once the job has been rescheduled I
am looking for a repot that will show all open
purchase orders (with the PO due date) with all the
operation start dates. This will allow us to quickly
review which PO's will not make it in on or before the new
operation start date. I cannot link the PORel table
with the JobMtl table-using queries. Any ideas?

Paul
3
Please explain why you can't link PORel to Jobmtl - I do this all the
time...


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
p_ksmith
Sent: April 15, 2005 8:55 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Help



I am working in Vantage 6.0 and I am having a hell of a time with the
following any help would be greatly appreciated. We are using the
scheduling module and due to priority changes some jobs will need
to be rescheduled. Once the job has been rescheduled I
am looking for a repot that will show all open
purchase orders (with the PO due date) with all the
operation start dates. This will allow us to quickly
review which PO's will not make it in on or before the new
operation start date. I cannot link the PORel table
with the JobMtl table-using queries. Any ideas?

Paul






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
4
First, Sarah thanks for responding. To date no one has been able to
help. I am using the business activity query to write reports. When I
select the table JobMtl the PORel table is removed. It is the same
situation when I select the PRRel table the JobMtl table is no longer
available. All I am looking for is a report that will show PO due
dates and Operation start dates. I can not link the tables to create
this report. Are you using the Business activity query? Again thanks
for the response.


Paul

--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> Please explain why you can't link PORel to Jobmtl - I do this all
the
> time...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> p_ksmith
> Sent: April 15, 2005 8:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Help
>
>
>
> I am working in Vantage 6.0 and I am having a hell of a time with
the
> following any help would be greatly appreciated. We are using the
> scheduling module and due to priority changes some jobs will need
> to be rescheduled. Once the job has been rescheduled I
> am looking for a repot that will show all open
> purchase orders (with the PO due date) with all the
> operation start dates. This will allow us to quickly
> review which PO's will not make it in on or before the new
> operation start date. I cannot link the PORel table
> with the JobMtl table-using queries. Any ideas?
>
> Paul
>
>
>
>
>
>
> 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
Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the
tables.

good luck.
6
You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the
tables.

good luck.


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
No, I don't use business activity query - I use either Report Builder,
crystal or access for my reports... if you use one of those, you should be
able to get what you want very easily...



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
p_ksmith
Sent: April 15, 2005 11:33 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Help



First, Sarah thanks for responding. To date no one has been able to
help. I am using the business activity query to write reports. When I
select the table JobMtl the PORel table is removed. It is the same
situation when I select the PRRel table the JobMtl table is no longer
available. All I am looking for is a report that will show PO due
dates and Operation start dates. I can not link the tables to create
this report. Are you using the Business activity query? Again thanks
for the response.


Paul

--- In vantage@yahoogroups.com, sarah.vareschi@n... wrote:
> Please explain why you can't link PORel to Jobmtl - I do this all
the
> time...
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> p_ksmith
> Sent: April 15, 2005 8:55 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Help
>
>
>
> I am working in Vantage 6.0 and I am having a hell of a time with
the
> following any help would be greatly appreciated. We are using the
> scheduling module and due to priority changes some jobs will need
> to be rescheduled. Once the job has been rescheduled I
> am looking for a repot that will show all open
> purchase orders (with the PO due date) with all the
> operation start dates. This will allow us to quickly
> review which PO's will not make it in on or before the new
> operation start date. I cannot link the PORel table
> with the JobMtl table-using queries. Any ideas?
>
> Paul
>
>
>
>
>
>
> 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
8
Now apply what Calvin just said to the BAQ.
Once you have used the wizard to make joins you can make, you can modify the
statement by hand.
Add the join following the syntax of other joins and you will be all set. I
do this all the time in the BAQ.
It's much like writing SQL statements by hand.

For example add...
each JobMtl Where JobMtl.Company = PORel.Company
and JobMtl.JobNum = PORel.JobNum
and JobMtl.AssemblySeq = PORel.AssemblySeq
and JobMtl.MtlSeq = PORel.JobSeq no-lock,
...
Good luck,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Calvin Dekker
Sent: Friday, April 15, 2005 12:12 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the
tables.

good luck.


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
9
Againthanks everyone for the help. I have joined all the tables but,
when I run the report it repeats. Here is the situation. We have a
job with 4 open purchase orders. I would like to compare the PO due
dates to the operation start dates. When I run the report it will not
show me just the 4 open PO and operetion start dates, it looks like
it repeats itself. I see al four PO's but also operations that are
not linked to the PO. Example
Job # Seq/Oper# Work Ctr Oper Start Date
2357-5 3/10 Sub/C start Date
2357-5 3/10 Sub/C Start Date
2357-5 3/10 Sub/C start Date
2357-5 3/10 Sub/C Start Date

Then it repeats
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''

2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''


Any idea why. Anyone else use a report to compare open PO's to
operation start dates? Thanks everyone so far for your help.


Paul

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Now apply what Calvin just said to the BAQ.
> Once you have used the wizard to make joins you can make, you can
modify the
> statement by hand.
> Add the join following the syntax of other joins and you will be
all set. I
> do this all the time in the BAQ.
> It's much like writing SQL statements by hand.
>
> For example add...
> each JobMtl Where JobMtl.Company = PORel.Company
> and JobMtl.JobNum = PORel.JobNum
> and JobMtl.AssemblySeq = PORel.AssemblySeq
> and JobMtl.MtlSeq = PORel.JobSeq no-lock,
> ...
> Good luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Calvin Dekker
> Sent: Friday, April 15, 2005 12:12 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Help
>
>
>
> You can't make the link in the BAQ but you can do this in Report
Builder or
> Crystal.
> There is no link since JobMtl.MtlSeq = PORel.JobSeq
>
> In Crystal or Report Builder do a LEFT OUTER JOIN and link as
follows:
> JobMtl.Company -> PORel.Company
> JobMtl.JobNum -> PORel.JobNum
> JobMtl.AssemblySeq -> PORel.AssemblySeq
> JobMtl.MtlSeq -> PORel.JobSeq
>
>
> HTH,
> Calvin
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of PLAMAN DICK
> Sent: Friday, April 15, 2005 10:42 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Help
>
>
>
> Paul,
> you will have to add another table or two. I was able to link
POHed to
> PORel to JobHed to JobMtl in the BAQ.
> Play around with this linkage, maybe you can eliminate one of the
> tables.
>
> good luck.
>
>
> 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
10
Make sure you add a filter on the po rel where jobseqtype = 'M'


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
p_ksmith
Sent: April 15, 2005 1:12 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Help



Againthanks everyone for the help. I have joined all the tables but,
when I run the report it repeats. Here is the situation. We have a
job with 4 open purchase orders. I would like to compare the PO due
dates to the operation start dates. When I run the report it will not
show me just the 4 open PO and operetion start dates, it looks like
it repeats itself. I see al four PO's but also operations that are
not linked to the PO. Example
Job # Seq/Oper# Work Ctr Oper Start Date
2357-5 3/10 Sub/C start Date
2357-5 3/10 Sub/C Start Date
2357-5 3/10 Sub/C start Date
2357-5 3/10 Sub/C Start Date

Then it repeats
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''

2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''


Any idea why. Anyone else use a report to compare open PO's to
operation start dates? Thanks everyone so far for your help.


Paul

--- In vantage@yahoogroups.com, "Aaron Hoyt" <aaron.hoyt@v...> wrote:
> Now apply what Calvin just said to the BAQ.
> Once you have used the wizard to make joins you can make, you can
modify the
> statement by hand.
> Add the join following the syntax of other joins and you will be
all set. I
> do this all the time in the BAQ.
> It's much like writing SQL statements by hand.
>
> For example add...
> each JobMtl Where JobMtl.Company = PORel.Company
> and JobMtl.JobNum = PORel.JobNum
> and JobMtl.AssemblySeq = PORel.AssemblySeq
> and JobMtl.MtlSeq = PORel.JobSeq no-lock,
> ...
> Good luck,
> Aaron Hoyt
> Vantage Plastics
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of Calvin Dekker
> Sent: Friday, April 15, 2005 12:12 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Help
>
>
>
> You can't make the link in the BAQ but you can do this in Report
Builder or
> Crystal.
> There is no link since JobMtl.MtlSeq = PORel.JobSeq
>
> In Crystal or Report Builder do a LEFT OUTER JOIN and link as
follows:
> JobMtl.Company -> PORel.Company
> JobMtl.JobNum -> PORel.JobNum
> JobMtl.AssemblySeq -> PORel.AssemblySeq
> JobMtl.MtlSeq -> PORel.JobSeq
>
>
> HTH,
> Calvin
>
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On
Behalf
> Of PLAMAN DICK
> Sent: Friday, April 15, 2005 10:42 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Re: Help
>
>
>
> Paul,
> you will have to add another table or two. I was able to link
POHed to
> PORel to JobHed to JobMtl in the BAQ.
> Play around with this linkage, maybe you can eliminate one of the
> tables.
>
> good luck.
>
>
> 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
11
You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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
12
Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to
choose fields it errors telling me no such field exists even
though I have selected it from the field list it gives me.

All my attempts have yielded errors. If someone has found a
way to perform LEFT and RIGHT OUTER joins in the BAQ, please
share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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
13
Calvin,
If I am not mistaken you can add in OUTER-JOIN to the query and it should
work. It's been months since I have played with this, but you should give
it a shot.
Beware, if there are joins made after the outer join, you will need to
specify them as outer as well.
I think it works like this...
each JobMtl OUTER-JOIN Where JobMtl.Company = PORel.Company
and JobMtl.JobNum = PORel.JobNum
and JobMtl.AssemblySeq = PORel.AssemblySeq
and JobMtl.MtlSeq = PORel.JobSeq no-lock,

Hope this helps,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Calvin Dekker
Sent: Monday, April 18, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to
choose fields it errors telling me no such field exists even
though I have selected it from the field list it gives me.

All my attempts have yielded errors. If someone has found a
way to perform LEFT and RIGHT OUTER joins in the BAQ, please
share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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
14
Aaron

What will the outer-join do. I am still trying to create a repot that
will show me operation start dates and PO due dates. I still can not get the
report to work. For some reason the report repeats itself (see below). Any
suggestions.

Again thanks everyone for the help. I have joined all the tables but,
when I run the report it repeats. Here is the situation. We have a
job with 4 open purchase orders. I would like to compare the PO due
dates to the operation start dates. When I run the report it will not
show me just the 4 open PO and operetion start dates, it looks like
it repeats itself. I see al four PO's but also operations that are
not linked to the PO. Example
Job # Seq/Oper# Work Ctr Oper Start Date
2357-5 3/10 Sub/C start Date
2357-5 3/10 Sub/C Start Date
2357-5 3/10 Sub/C start Date
2357-5 3/10 Sub/C Start Date

Then it repeats
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''
2357-5 3/40 Insp '' ''

2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''
2357-5 3/40 Test '' ''


Any idea why. Anyone else use a report to compare open PO's to
operation start dates? Thanks everyone so far for your help.


Paul

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Aaron Hoyt
Sent: Monday, April 18, 2005 9:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


Calvin,
If I am not mistaken you can add in OUTER-JOIN to the query and it should
work. It's been months since I have played with this, but you should give
it a shot.
Beware, if there are joins made after the outer join, you will need to
specify them as outer as well.
I think it works like this...
each JobMtl OUTER-JOIN Where JobMtl.Company = PORel.Company
and JobMtl.JobNum = PORel.JobNum
and JobMtl.AssemblySeq = PORel.AssemblySeq
and JobMtl.MtlSeq = PORel.JobSeq no-lock,

Hope this helps,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Calvin Dekker
Sent: Monday, April 18, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to
choose fields it errors telling me no such field exists even
though I have selected it from the field list it gives me.

All my attempts have yielded errors. If someone has found a
way to perform LEFT and RIGHT OUTER joins in the BAQ, please
share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder
or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

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]
15
Calvin,

Query sample using Left Outer Join:
for each LaborDtl no-lock where LaborDtl.Company = CUR-COMP
and LaborDtl.PayrollDate = Today,
first EmpBasic outer-join no-lock where EmpBasic.Company = LaborDtl.Company
and EmpBasic.EmpId = LaborDtl.EmployeeNum,


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Monday, April 18, 2005 8:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to choose fields
it errors telling me no such field exists even though I have selected it
from the field list it gives me.

All my attempts have yielded errors. If someone has found a way to perform
LEFT and RIGHT OUTER joins in the BAQ, please share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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
16
Aaron -

That is the problem once you specify the outer-join
the error comes back that the field isn't available
for display.

ie: jobmtl.jobnum - no such field in query.

If you leave the join equal, the field is available
but you don't have the correct data set for the report.
one little detail!

Would suggest taking this report back to crystal or
report builder.

HTH,
Calvin


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Aaron Hoyt
Sent: Monday, April 18, 2005 8:58 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Calvin,
If I am not mistaken you can add in OUTER-JOIN to the query and it should
work. It's been months since I have played with this, but you should give
it a shot.
Beware, if there are joins made after the outer join, you will need to
specify them as outer as well.
I think it works like this...
each JobMtl OUTER-JOIN Where JobMtl.Company = PORel.Company
and JobMtl.JobNum = PORel.JobNum
and JobMtl.AssemblySeq = PORel.AssemblySeq
and JobMtl.MtlSeq = PORel.JobSeq no-lock,

Hope this helps,
Aaron Hoyt
Vantage Plastics

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Calvin Dekker
Sent: Monday, April 18, 2005 9:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to
choose fields it errors telling me no such field exists even
though I have selected it from the field list it gives me.

All my attempts have yielded errors. If someone has found a
way to perform LEFT and RIGHT OUTER joins in the BAQ, please
share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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
17
Pat -

Try the syntax you sent and then add fields to the query to be displayed.

All I get is the following errors:
Unable to understand after "open" (247)
Invalid statement (254)
Could not understand line 24. (198)
Missing FOR, FIND, or CREATE for a table with Company in current block
(232)
Could not understand line 30 (196)

The syntax works for me in a stand alone program but not in the BAQ.

Am I the only one getting errors when I try to run the BAQ?

Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, April 18, 2005 9:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Calvin,

Query sample using Left Outer Join:
for each LaborDtl no-lock where LaborDtl.Company = CUR-COMP
and LaborDtl.PayrollDate = Today,
first EmpBasic outer-join no-lock where EmpBasic.Company = LaborDtl.Company
and EmpBasic.EmpId = LaborDtl.EmployeeNum,


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Monday, April 18, 2005 8:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to choose fields
it errors telling me no such field exists even though I have selected it
from the field list it gives me.

All my attempts have yielded errors. If someone has found a way to perform
LEFT and RIGHT OUTER joins in the BAQ, please share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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
18
Calvin,
Try this query...

for each EmpBasic outer-join Where EmpBasic.Company = cur-comp no-lock,

first LaborDtl outer-join Where LaborDtl.Company = EmpBasic.Company
and LaborDtl.ActiveTrans = yes
and LaborDtl.EmployeeNum = EmpBasic.EmpID no-lock
BY LaborDtl.EmployeeNum:

It works for me.
It worked with the join in either direction, but for an outer join, it
seemed more sensible to be looking from he EmpBasic to the LaborDtl as every
LaborDtl should have one and only one employee linked.
I think it was the rest of the query that was giving problems not the join.

Good luck,
Aaron Hoyt


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of Calvin Dekker
Sent: Monday, April 18, 2005 11:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Pat -

Try the syntax you sent and then add fields to the query to be displayed.

All I get is the following errors:
Unable to understand after "open" (247)
Invalid statement (254)
Could not understand line 24. (198)
Missing FOR, FIND, or CREATE for a table with Company in current block
(232)
Could not understand line 30 (196)

The syntax works for me in a stand alone program but not in the BAQ.

Am I the only one getting errors when I try to run the BAQ?

Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf
Of pjw@...
Sent: Monday, April 18, 2005 9:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Calvin,

Query sample using Left Outer Join:
for each LaborDtl no-lock where LaborDtl.Company = CUR-COMP
and LaborDtl.PayrollDate = Today,
first EmpBasic outer-join no-lock where EmpBasic.Company = LaborDtl.Company
and EmpBasic.EmpId = LaborDtl.EmployeeNum,


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Monday, April 18, 2005 8:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to choose fields
it errors telling me no such field exists even though I have selected it
from the field list it gives me.

All my attempts have yielded errors. If someone has found a way to perform
LEFT and RIGHT OUTER joins in the BAQ, please share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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
19
Calvin,

Below is the full BAQ statement, It works on my system. Hope this helps.


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



for each LaborDtl no-lock where LaborDtl.Company = CUR-COMP
and LaborDtl.PayrollDate = Today,
first EmpBasic outer-join no-lock where EmpBasic.Company = LaborDtl.Company
and EmpBasic.EmpId = LaborDtl.EmployeeNum
by empbasic.empid:



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Monday, April 18, 2005 10:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


Pat -

Try the syntax you sent and then add fields to the query to be displayed.

All I get is the following errors:
Unable to understand after "open" (247)
Invalid statement (254)
Could not understand line 24. (198)
Missing FOR, FIND, or CREATE for a table with Company in current
block
(232)
Could not understand line 30 (196)

The syntax works for me in a stand alone program but not in the BAQ.

Am I the only one getting errors when I try to run the BAQ?

Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
pjw@...
Sent: Monday, April 18, 2005 9:24 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Calvin,

Query sample using Left Outer Join:
for each LaborDtl no-lock where LaborDtl.Company = CUR-COMP
and LaborDtl.PayrollDate = Today,
first EmpBasic outer-join no-lock where EmpBasic.Company = LaborDtl.Company
and EmpBasic.EmpId = LaborDtl.EmployeeNum,


Patrick Winter
sSc Specialty Screw Corporation
Vantage 6.10.514, Progress 9.1D08, Windows 2003 Server, Crystal 8.5.3.975



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Monday, April 18, 2005 8:51 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


Pat -

I can't seem to find the syntax for a LEFT-OUTER join in BAQ.
Once I type in the correct syntax for the link, when I try to choose fields
it errors telling me no such field exists even though I have selected it
from the field list it gives me.

All my attempts have yielded errors. If someone has found a way to perform
LEFT and RIGHT OUTER joins in the BAQ, please share with the group.

Thanks,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
pjw@...
Sent: Monday, April 18, 2005 8:16 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



You can't in BAQ?
What's the hold up? Can't you type in the link outside the wizard?


Patrick Winter


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Calvin Dekker
Sent: Friday, April 15, 2005 11:12 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help


You can't make the link in the BAQ but you can do this in Report Builder or
Crystal.
There is no link since JobMtl.MtlSeq = PORel.JobSeq

In Crystal or Report Builder do a LEFT OUTER JOIN and link as follows:
JobMtl.Company -> PORel.Company
JobMtl.JobNum -> PORel.JobNum
JobMtl.AssemblySeq -> PORel.AssemblySeq
JobMtl.MtlSeq -> PORel.JobSeq


HTH,
Calvin



-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
PLAMAN DICK
Sent: Friday, April 15, 2005 10:42 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Re: Help



Paul,
you will have to add another table or two. I was able to link POHed to
PORel to JobHed to JobMtl in the BAQ.
Play around with this linkage, maybe you can eliminate one of the tables.

good luck.


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










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
20
Help my consultant gone away with no contact

Problem

Copy database from live to test now printing of report,s is not
working have check localhost number and folder direction can anybody
help?

System Monitor just says Schuduled task Immediate Run Request