As far as Crystal goes, I I've successfully done two Left-outer joins, but not right-outer (haven't tried). Typically, though, Crystal 7 didn't do joins well for me, besides the very simple ones. Crystal 8 is much better in all respects as far as multiple parent-child joins, etc.

Note, what Crystal DOES give you, is the ability to do subreports, which has allowed me to write reports that I could NEVER do in Report Builder. That's the key functionality of Crystal in my opinion. You do sacrifice speed, however, when using subreports - especially if the subreport is in the details sections.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Nigel Roberts
To: 'Vantage User List (US)'
Sent: Friday, March 16, 2001 4:30 AM
Subject: [Vantage] Report Builder Query

Hi all,

I've been trying to write a report showing order releases, all
associated shipments made and all associated job operation times. It
appears to be impossible to acheive two 'right-outer' joins in a report
- does anyone know a way around this?
If not, is it possible in Crystal assuming I go down the ODBC route?

Thanks for any help in advance,

Nigel Roberts
MC Sheet Metal Limited
Wales, UK.

Yahoo! Groups Sponsor

Click Here to Find Software Faster

To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

Speaking of attaching to Vantage via Crystal Pro/ODBC. Does crystal
pro/odbc allow me to attach to/report from the payroll tables the way RB
does not?

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Troy Funte [mailto:tfunte@...]
Sent: Friday, March 16, 2001 7:51 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report Builder Query

As far as Crystal goes, I I've successfully done two Left-outer joins, but
not right-outer (haven't tried). Typically, though, Crystal 7 didn't do
joins well for me, besides the very simple ones. Crystal 8 is much better in
all respects as far as multiple parent-child joins, etc.

Note, what Crystal DOES give you, is the ability to do subreports, which has
allowed me to write reports that I could NEVER do in Report Builder. That's
the key functionality of Crystal in my opinion. You do sacrifice speed,
however, when using subreports - especially if the subreport is in the
details sections.

Troy Funte
Liberty Electronics

----- Original Message -----
From: Nigel Roberts
To: 'Vantage User List (US)'
Sent: Friday, March 16, 2001 4:30 AM
Subject: [Vantage] Report Builder Query

Hi all,

I've been trying to write a report showing order releases, all
associated shipments made and all associated job operation times. It
appears to be impossible to acheive two 'right-outer' joins in a report
- does anyone know a way around this?
If not, is it possible in Crystal assuming I go down the ODBC route?

Thanks for any help in advance,

Nigel Roberts
MC Sheet Metal Limited
Wales, UK.

Yahoo! Groups Sponsor

Click Here to Find Software Faster

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.

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

Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridTime&t=ad>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

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]

Just tried it and it worked fine.

Terry Williams wrote:

>
> Speaking of attaching to Vantage via Crystal Pro/ODBC. Does crystal
> pro/odbc allow me to attach to/report from the payroll tables the way RB
> does not?
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@...
> <mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Friday, March 16, 2001 7:51 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Report Builder Query
>
> As far as Crystal goes, I I've successfully done two Left-outer joins, but
> not right-outer (haven't tried). Typically, though, Crystal 7 didn't do
> joins well for me, besides the very simple ones. Crystal 8 is much better in
> all respects as far as multiple parent-child joins, etc.
>
> Note, what Crystal DOES give you, is the ability to do subreports, which has
> allowed me to write reports that I could NEVER do in Report Builder. That's
> the key functionality of Crystal in my opinion. You do sacrifice speed,
> however, when using subreports - especially if the subreport is in the
> details sections.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Nigel Roberts
> To: 'Vantage User List (US)'
> Sent: Friday, March 16, 2001 4:30 AM
> Subject: [Vantage] Report Builder Query
>
> Hi all,
>
> I've been trying to write a report showing order releases, all
> associated shipments made and all associated job operation times. It
> appears to be impossible to acheive two 'right-outer' joins in a report
> - does anyone know a way around this?
> If not, is it possible in Crystal assuming I go down the ODBC route?
>
> Thanks for any help in advance,
>
> Nigel Roberts
> MC Sheet Metal Limited
> Wales, UK.
>
> Yahoo! Groups Sponsor
>
> Click Here to Find Software Faster
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have already
> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> [Non-text portions of this message have been removed]
>
> Yahoo! Groups Sponsor
> Click Here to Find Software Faster
> Click Here to Find Software Faster
> <http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
> 599088/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
> ersInternet_Software_WhiteGridTime&t=ad>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have already
> linked your email address to a yahoo id to enable access.
>
> 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]
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please go to: http://groups.yahoo.com/group/vantage/files/. Note: You must have already linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/

That's all I wanted to know. Thanks, Joe.

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Joe Konecny [mailto:jkonecn@...]
Sent: Friday, March 16, 2001 11:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report Builder Query

Just tried it and it worked fine.

Terry Williams wrote:

>
> Speaking of attaching to Vantage via Crystal Pro/ODBC. Does crystal
> pro/odbc allow me to attach to/report from the payroll tables the way RB
> does not?
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@...
> <mailto:tlw@...> www.chipsco.com < http://www.chipsco.com/>
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Friday, March 16, 2001 7:51 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Report Builder Query
>
> As far as Crystal goes, I I've successfully done two Left-outer joins, but
> not right-outer (haven't tried). Typically, though, Crystal 7 didn't do
> joins well for me, besides the very simple ones. Crystal 8 is much better

> all respects as far as multiple parent-child joins, etc.
>
> Note, what Crystal DOES give you, is the ability to do subreports, which

has

> allowed me to write reports that I could NEVER do in Report Builder.

That's

> the key functionality of Crystal in my opinion. You do sacrifice speed,
> however, when using subreports - especially if the subreport is in the
> details sections.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Nigel Roberts
> To: 'Vantage User List (US)'
> Sent: Friday, March 16, 2001 4:30 AM
> Subject: [Vantage] Report Builder Query
>
> Hi all,
>
> I've been trying to write a report showing order releases, all
> associated shipments made and all associated job operation times. It
> appears to be impossible to acheive two 'right-outer' joins in a report
> - does anyone know a way around this?
> If not, is it possible in Crystal assuming I go down the ODBC route?
>
> Thanks for any help in advance,
>
> Nigel Roberts
> MC Sheet Metal Limited
> Wales, UK.
>
> Yahoo! Groups Sponsor
>
> Click Here to Find Software Faster
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have

already

> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> [Non-text portions of this message have been removed]
>
> Yahoo! Groups Sponsor
> Click Here to Find Software Faster
> Click Here to Find Software Faster
> <

http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=

> 599088/*

http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
<http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput>

> ersInternet_Software_WhiteGridTime&t=ad>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have

already

> linked your email address to a yahoo id to enable access.
>
> 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]
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and

Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

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

Yahoo! Groups Sponsor
Click Here to Find Software Faster
Click Here to Find Software Faster
<http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=
599089/*http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
ersInternet_Software_WhiteGridOptions&t=ad>

To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

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]

P.S. Joe, What version of Crystal?

Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
16335 814-333-6331 fax: 814-337-2548 tlw@...
<mailto:tlw@...> www.chipsco.com <http://www.chipsco.com/>

-----Original Message-----
From: Joe Konecny [mailto:jkonecn@...]
Sent: Friday, March 16, 2001 11:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Report Builder Query

Just tried it and it worked fine.

Terry Williams wrote:

>
> Speaking of attaching to Vantage via Crystal Pro/ODBC. Does crystal
> pro/odbc allow me to attach to/report from the payroll tables the way RB
> does not?
>
> Terry L. Williams Chipsco, Inc. 9936 Liberty St. Ext. Meadville, PA
> 16335 814-333-6331 fax: 814-337-2548 tlw@...
> <mailto:tlw@...> www.chipsco.com < http://www.chipsco.com/>
>
> -----Original Message-----
> From: Troy Funte [mailto:tfunte@...]
> Sent: Friday, March 16, 2001 7:51 AM
> To: vantage@yahoogroups.com
> Subject: Re: [Vantage] Report Builder Query
>
> As far as Crystal goes, I I've successfully done two Left-outer joins, but
> not right-outer (haven't tried). Typically, though, Crystal 7 didn't do
> joins well for me, besides the very simple ones. Crystal 8 is much better

> all respects as far as multiple parent-child joins, etc.
>
> Note, what Crystal DOES give you, is the ability to do subreports, which

has

> allowed me to write reports that I could NEVER do in Report Builder.

That's

> the key functionality of Crystal in my opinion. You do sacrifice speed,
> however, when using subreports - especially if the subreport is in the
> details sections.
>
> Troy Funte
> Liberty Electronics
>
> ----- Original Message -----
> From: Nigel Roberts
> To: 'Vantage User List (US)'
> Sent: Friday, March 16, 2001 4:30 AM
> Subject: [Vantage] Report Builder Query
>
> Hi all,
>
> I've been trying to write a report showing order releases, all
> associated shipments made and all associated job operation times. It
> appears to be impossible to acheive two 'right-outer' joins in a report
> - does anyone know a way around this?
> If not, is it possible in Crystal assuming I go down the ODBC route?
>
> Thanks for any help in advance,
>
> Nigel Roberts
> MC Sheet Metal Limited
> Wales, UK.
>
> Yahoo! Groups Sponsor
>
> Click Here to Find Software Faster
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have

already

> linked your email address to a yahoo id to enable access.
>
> Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
>
> [Non-text portions of this message have been removed]
>
> Yahoo! Groups Sponsor
> Click Here to Find Software Faster
> Click Here to Find Software Faster
> <

http://rd.yahoo.com/M=162801.1342103.2934627/D=egroupmail/S=1700007183:N/A=

> 599088/*

http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput
<http://www.knowledgestorm.com/jump_white.html?c=Yahoo&n=eLert_Comput>

> ersInternet_Software_WhiteGridTime&t=ad>
>
> To access the Files Section of our Yahoo!Group for Report Builder and
> Crystal Reports and other 'goodies', please go to:
> http://groups.yahoo.com/group/vantage/files/. Note: You must have

already

> linked your email address to a yahoo id to enable access.
>
> 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]
>
>
> To access the Files Section of our Yahoo!Group for Report Builder and

Crystal Reports and other 'goodies', please go to:
http://groups.yahoo.com/group/vantage/files/. Note: You must have already
linked your email address to a yahoo id to enable access.

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