Outer join

I was given these instruction awhile back maybe they will help.

LEFT OUTER JOIN ERROR FIX

PROBLEM DESCRIPTION: Getting error: "Error Detected by Database
Dll" or "LEFT OUTER JOIN" Error when previewing Crystal Report
created against ODBC Connection to Databse

To fix this problem with Crystal 7, 8 or 8.5 do the following:

1) Save the file Outjoin File.REG. Double click on the file. This
will import the correct registry information to your workstation's
registry.

2) After adding the registry entry from step 1, you will need to
edit the registry key below adding in the following "word" depending
on the ODBC driver version you are using.

- add "pgpro915" (Merant 3.60 SQL-92 Driver for 9.1x) loaded by
default for Vantage 5.00, 5.10, 5.20, 6.00)

Add the values to the OpenIngres value in the following registry key:

To open the registry, go to [START] --> Run, type in: regedit
Click [OK].

Double click down through the path below. Locate the OpenIngres
value and double click on it. Add the correct value from above.

HKEY_CURRENT_USER\Software\Seagate Software\Crystal
Reports\DatabaseOptions\OuterJoin


Example: oplodbc,oplodb32,pgpro915


Dan Ernst
Computer Services
Correct Craft, Inc.
(407) 855-4141
http://www.correctcraft.com
--- In vantage@yahoogroups.com, "Mesick, Todd" <tmesick@t...> wrote:
> I have installed the patches with not luck as of yet.
>
> Thanks
> Todd
>
>
> -----Original Message-----
> From: Manasa Reddy [mailto:mreddy@c...]
> Sent: Thursday, June 16, 2005 8:03 AM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Outer join
>
>
> Todd:
>
> I think there was a patch you had to install for Crystal for
> the outer joins.
>
> Did you apply it? It should be located on Epicor's website
> where you would download patches for Vantage.
>
> HTH,
>
>
> M. Manasa Reddy
> ERP Specialist
> Crestview Aerospace Corporation
> Email: mreddy@c...
> Phone: (850) 682-2746 x 272
>
>
> -----Original Message-----
> From: vantage@yahoogroups.com
> [mailto:vantage@yahoogroups.com]On Behalf Of Mesick, Todd
> Sent: Thursday, June 16, 2005 6:45 AM
> To: 'vantage@yahoogroups.com'
> Subject: RE: [Vantage] Outer join
>
>
> Yes, It seems to hang on the queries and never return
> anything, when I use
> them.
>
> Specifically I have modified the pack slip to included
> customer serial
> numbers on the pack slip.
>
> When there is no serial numbers I would like to use the
> outer join to
> continue processing and return the rest of the data(ie
> customer po, po line)
>
> Thanks for your help
> Todd
>
>
> -----Original Message-----
> From: Brandon Murch [mailto:bmurch@w...]
> Sent: Wednesday, June 15, 2005 4:47 PM
> To: vantage@yahoogroups.com
> Subject: RE: [Vantage] Outer join
>
>
> Yes...is there more to the question?
>
> Brandon R Murch
> Supervisor of Information Technology
> WindStone Medical Packaging
> 406.259.6387
> bmurch@w...
> <mailto:bmurch@w...>
>
> -----Original Message-----
> From: Mesick, Todd [mailto:tmesick@t...]
> Sent: Wednesday, June 15, 2005 2:29 PM
> To: 'vantage@yahoogroups.com'
> Subject: [Vantage] Outer join
>
> Anyone have any luck using outer joins in crystal 8.5 with
> progress
> 9.1d?
>
> Thanks
> Todd Mesick
>
> TECT Proprietary & Confidential. This message, along with
> any
> attachments,
> is intended only for the exclusive use of the individual
> or entity to
> which
> it is addressed and may contain information that is
> privileged,
> confidential
> and exempt from disclosure. If you are not the intended
> recipient, you
> are
> hereby notified that any dissemination, distribution, or
> copying of this
> message, or any attachment, is strictly prohibited. If
> you have
> received
> this message in error, please notify the original sender
> immediately by
> return email, or by calling 229-228-2600, and delete the
> message, along
> with
> any attachments, from your computer.
>
>
> [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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> < http://groups.yahoo.com/group/vantage/files/.
> <http://groups.yahoo.com/group/vantage/files/.> >
> < http://groups.yahoo.com/group/vantage/files/
> <http://groups.yahoo.com/group/vantage/files/>
> < 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>
> < 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>
> < http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links> >
>
>
>
> _____
>
> Yahoo! Groups Links
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
> < http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/> >
>
> * To unsubscribe from this group, send an email
> to:
> vantage-unsubscribe@yahoogroups.com
>
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
> ibe>
>
> * Your use of Yahoo! Groups is subject to the
> Yahoo! Terms of
> Service < http://docs.yahoo.com/info/terms/
> <http://docs.yahoo.com/info/terms/>
> < http://docs.yahoo.com/info/terms/
<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/.
> <http://groups.yahoo.com/group/vantage/files/.>
> < 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>
> < 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>
> < http://groups.yahoo.com/group/vantage/links
> <http://groups.yahoo.com/group/vantage/links> >
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
> < http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/> >
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
>
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
> ibe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo!
> Terms of Service
> < http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/> >
> .
>
>
> TECT Proprietary & Confidential. This message, along with
> any attachments,
> is intended only for the exclusive use of the individual
> or entity to which
> it is addressed and may contain information that is
> privileged, confidential
> and exempt from disclosure. If you are not the intended
> recipient, you are
> hereby notified that any dissemination, distribution, or
> copying of this
> message, or any attachment, is strictly prohibited. If
> you have received
> this message in error, please notify the original sender
> immediately by
> return email, or by calling 229-228-2600, and delete the
> message, along with
> any attachments, from your computer.
>
>
> [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/.
> <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>
>
>
>
> ------------------------------------------------------------
> ------------------
> Yahoo! Groups Links
>
> a.. To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <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]
>
>
>
> 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>
>
>
>
> _____
>
> Yahoo! Groups Links
>
>
> * To visit your group on the web, go to:
> http://groups.yahoo.com/group/vantage/
> <http://groups.yahoo.com/group/vantage/>
>
>
> * To unsubscribe from this group, send an email to:
> vantage-unsubscribe@yahoogroups.com
> <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>
>
>
> * Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service
> <http://docs.yahoo.com/info/terms/> .
>
>
> TECT Proprietary & Confidential. This message, along with any
attachments,
> is intended only for the exclusive use of the individual or entity
to which
> it is addressed and may contain information that is privileged,
confidential
> and exempt from disclosure. If you are not the intended
recipient, you are
> hereby notified that any dissemination, distribution, or copying
of this
> message, or any attachment, is strictly prohibited. If you have
received
> this message in error, please notify the original sender
immediately by
> return email, or by calling 229-228-2600, and delete the message,
along with
> any attachments, from your computer.
>
>
> [Non-text portions of this message have been removed]
Anyone have any luck using outer joins in crystal 8.5 with progress 9.1d?

Thanks
Todd Mesick

TECT Proprietary & Confidential. This message, along with any attachments,
is intended only for the exclusive use of the individual or entity to which
it is addressed and may contain information that is privileged, confidential
and exempt from disclosure. If you are not the intended recipient, you are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along with
any attachments, from your computer.


[Non-text portions of this message have been removed]
Yes...is there more to the question?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Mesick, Todd [mailto:tmesick@...]
Sent: Wednesday, June 15, 2005 2:29 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Outer join

Anyone have any luck using outer joins in crystal 8.5 with progress
9.1d?

Thanks
Todd Mesick

TECT Proprietary & Confidential. This message, along with any
attachments,
is intended only for the exclusive use of the individual or entity to
which
it is addressed and may contain information that is privileged,
confidential
and exempt from disclosure. If you are not the intended recipient, you
are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have
received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along
with
any attachments, from your computer.


[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/.
<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
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* 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]
Yes, It seems to hang on the queries and never return anything, when I use
them.

Specifically I have modified the pack slip to included customer serial
numbers on the pack slip.

When there is no serial numbers I would like to use the outer join to
continue processing and return the rest of the data(ie customer po, po line)

Thanks for your help
Todd


-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Wednesday, June 15, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Outer join


Yes...is there more to the question?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@... <mailto:bmurch@...>

-----Original Message-----
From: Mesick, Todd [mailto:tmesick@...]
Sent: Wednesday, June 15, 2005 2:29 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Outer join

Anyone have any luck using outer joins in crystal 8.5 with progress
9.1d?

Thanks
Todd Mesick

TECT Proprietary & Confidential. This message, along with any
attachments,
is intended only for the exclusive use of the individual or entity to
which
it is addressed and may contain information that is privileged,
confidential
and exempt from disclosure. If you are not the intended recipient, you
are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have
received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along
with
any attachments, from your computer.


[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/.
<http://groups.yahoo.com/group/vantage/files/.>
< 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>



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>

* Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/
<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/.
<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>



_____

Yahoo! Groups Links


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


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


TECT Proprietary & Confidential. This message, along with any attachments,
is intended only for the exclusive use of the individual or entity to which
it is addressed and may contain information that is privileged, confidential
and exempt from disclosure. If you are not the intended recipient, you are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along with
any attachments, from your computer.


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

I think there was a patch you had to install for Crystal for
the outer joins.

Did you apply it? It should be located on Epicor's website
where you would download patches for Vantage.

HTH,


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


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Mesick, Todd
Sent: Thursday, June 16, 2005 6:45 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Outer join


Yes, It seems to hang on the queries and never return
anything, when I use
them.

Specifically I have modified the pack slip to included
customer serial
numbers on the pack slip.

When there is no serial numbers I would like to use the
outer join to
continue processing and return the rest of the data(ie
customer po, po line)

Thanks for your help
Todd


-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Wednesday, June 15, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Outer join


Yes...is there more to the question?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...
<mailto:bmurch@...>

-----Original Message-----
From: Mesick, Todd [mailto:tmesick@...]
Sent: Wednesday, June 15, 2005 2:29 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Outer join

Anyone have any luck using outer joins in crystal 8.5 with
progress
9.1d?

Thanks
Todd Mesick

TECT Proprietary & Confidential. This message, along with
any
attachments,
is intended only for the exclusive use of the individual
or entity to
which
it is addressed and may contain information that is
privileged,
confidential
and exempt from disclosure. If you are not the intended
recipient, you
are
hereby notified that any dissemination, distribution, or
copying of this
message, or any attachment, is strictly prohibited. If
you have
received
this message in error, please notify the original sender
immediately by
return email, or by calling 229-228-2600, and delete the
message, along
with
any attachments, from your computer.


[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/.
<http://groups.yahoo.com/group/vantage/files/.>
< 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>



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>

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

<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>

* Your use of Yahoo! Groups is subject to the
Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/
<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/.
<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>



_____

Yahoo! Groups Links


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


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

<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>


* Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service
<http://docs.yahoo.com/info/terms/> .


TECT Proprietary & Confidential. This message, along with
any attachments,
is intended only for the exclusive use of the individual
or entity to which
it is addressed and may contain information that is
privileged, confidential
and exempt from disclosure. If you are not the intended
recipient, you are
hereby notified that any dissemination, distribution, or
copying of this
message, or any attachment, is strictly prohibited. If
you have received
this message in error, please notify the original sender
immediately by
return email, or by calling 229-228-2600, and delete the
message, along with
any attachments, from your computer.


[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



------------------------------------------------------------
------------------
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]
I have installed the patches with not luck as of yet.

Thanks
Todd


-----Original Message-----
From: Manasa Reddy [mailto:mreddy@...]
Sent: Thursday, June 16, 2005 8:03 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Outer join


Todd:

I think there was a patch you had to install for Crystal for
the outer joins.

Did you apply it? It should be located on Epicor's website
where you would download patches for Vantage.

HTH,


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


-----Original Message-----
From: vantage@yahoogroups.com
[mailto:vantage@yahoogroups.com]On Behalf Of Mesick, Todd
Sent: Thursday, June 16, 2005 6:45 AM
To: 'vantage@yahoogroups.com'
Subject: RE: [Vantage] Outer join


Yes, It seems to hang on the queries and never return
anything, when I use
them.

Specifically I have modified the pack slip to included
customer serial
numbers on the pack slip.

When there is no serial numbers I would like to use the
outer join to
continue processing and return the rest of the data(ie
customer po, po line)

Thanks for your help
Todd


-----Original Message-----
From: Brandon Murch [mailto:bmurch@...]
Sent: Wednesday, June 15, 2005 4:47 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Outer join


Yes...is there more to the question?

Brandon R Murch
Supervisor of Information Technology
WindStone Medical Packaging
406.259.6387
bmurch@...
<mailto:bmurch@...>

-----Original Message-----
From: Mesick, Todd [mailto:tmesick@...]
Sent: Wednesday, June 15, 2005 2:29 PM
To: 'vantage@yahoogroups.com'
Subject: [Vantage] Outer join

Anyone have any luck using outer joins in crystal 8.5 with
progress
9.1d?

Thanks
Todd Mesick

TECT Proprietary & Confidential. This message, along with
any
attachments,
is intended only for the exclusive use of the individual
or entity to
which
it is addressed and may contain information that is
privileged,
confidential
and exempt from disclosure. If you are not the intended
recipient, you
are
hereby notified that any dissemination, distribution, or
copying of this
message, or any attachment, is strictly prohibited. If
you have
received
this message in error, please notify the original sender
immediately by
return email, or by calling 229-228-2600, and delete the
message, along
with
any attachments, from your computer.


[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/.
<http://groups.yahoo.com/group/vantage/files/.>
< http://groups.yahoo.com/group/vantage/files/.
<http://groups.yahoo.com/group/vantage/files/.> >
< http://groups.yahoo.com/group/vantage/files/
<http://groups.yahoo.com/group/vantage/files/>
< 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>
< 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>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >



_____

Yahoo! Groups Links
* To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/>
< http://groups.yahoo.com/group/vantage/
<http://groups.yahoo.com/group/vantage/> >

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

<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>

* Your use of Yahoo! Groups is subject to the
Yahoo! Terms of
Service < http://docs.yahoo.com/info/terms/
<http://docs.yahoo.com/info/terms/>
< http://docs.yahoo.com/info/terms/ <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/.
<http://groups.yahoo.com/group/vantage/files/.>
< 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>
< 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>
< http://groups.yahoo.com/group/vantage/links
<http://groups.yahoo.com/group/vantage/links> >



_____

Yahoo! Groups Links


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


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

<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscr
ibe>


* Your use of Yahoo! Groups is subject to the Yahoo!
Terms of Service
< http://docs.yahoo.com/info/terms/ <http://docs.yahoo.com/info/terms/> >
.


TECT Proprietary & Confidential. This message, along with
any attachments,
is intended only for the exclusive use of the individual
or entity to which
it is addressed and may contain information that is
privileged, confidential
and exempt from disclosure. If you are not the intended
recipient, you are
hereby notified that any dissemination, distribution, or
copying of this
message, or any attachment, is strictly prohibited. If
you have received
this message in error, please notify the original sender
immediately by
return email, or by calling 229-228-2600, and delete the
message, along with
any attachments, from your computer.


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



------------------------------------------------------------
------------------
Yahoo! Groups Links

a.. To visit your group on the web, go to:
http://groups.yahoo.com/group/vantage/
<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]



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>



_____

Yahoo! Groups Links


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


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com
<mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service
<http://docs.yahoo.com/info/terms/> .


TECT Proprietary & Confidential. This message, along with any attachments,
is intended only for the exclusive use of the individual or entity to which
it is addressed and may contain information that is privileged, confidential
and exempt from disclosure. If you are not the intended recipient, you are
hereby notified that any dissemination, distribution, or copying of this
message, or any attachment, is strictly prohibited. If you have received
this message in error, please notify the original sender immediately by
return email, or by calling 229-228-2600, and delete the message, along with
any attachments, from your computer.


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