Ok, that makes sense...thanks for the explanation....
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Friday, July 27, 2007 1:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Manasa
The reason I ask this, is that if you place outer joins on the inside of
an inner join it will error
Example
This runs
Customer -> Inner -> Sales Order Header -> Inner -> Sales Order line ->
Inner -> Sales Order Release
This runs
Customer -> Inner -> Sales Order Header -> Outer -> Sales Order line ->
Outer -> Sales Order Release
This would not run and give the type of error you have
Customer -> Inner -> Sales Order Header -> Outer -> Sales Order line ->
Inner -> Sales Order Release
Gary Parfrey
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: 26 July 2007 20:33
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Yep it does...what a pain in the ass....
So I can't have different types of joins?
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, July 26, 2007 1:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Manasa
If you change them all to outer joins does it run?
Gary
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: 26 July 2007 19:25
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
What I did was create it first with inner joins, then changed one or two
of the joins to left outer....yes, there is still some inner joins in
there.
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, July 26, 2007 12:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Do you have any inner joins in your dataset, as well as the outer join?
Gary Parfrey
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: 26 July 2007 15:24
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal XI and Left OuterJoin
Anytime I use a left outer join I get a "Failed to retrieve data from
the database" message.
Anyone have issues with this? Is there a fix for it? If so where do I
get it?
TIA,
M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
M. Manasa Reddy
manasa@...
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Gary Parfrey
Sent: Friday, July 27, 2007 1:46 AM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Manasa
The reason I ask this, is that if you place outer joins on the inside of
an inner join it will error
Example
This runs
Customer -> Inner -> Sales Order Header -> Inner -> Sales Order line ->
Inner -> Sales Order Release
This runs
Customer -> Inner -> Sales Order Header -> Outer -> Sales Order line ->
Outer -> Sales Order Release
This would not run and give the type of error you have
Customer -> Inner -> Sales Order Header -> Outer -> Sales Order line ->
Inner -> Sales Order Release
Gary Parfrey
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: 26 July 2007 20:33
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Yep it does...what a pain in the ass....
So I can't have different types of joins?
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, July 26, 2007 1:38 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Manasa
If you change them all to outer joins does it run?
Gary
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: 26 July 2007 19:25
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
What I did was create it first with inner joins, then changed one or two
of the joins to left outer....yes, there is still some inner joins in
there.
M. Manasa Reddy
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
________________________________
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Gary Parfrey
Sent: Thursday, July 26, 2007 12:04 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: RE: [Vantage] Crystal XI and Left OuterJoin
Do you have any inner joins in your dataset, as well as the outer join?
Gary Parfrey
Dot Net IT Limited, Reg No 4412519
From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Manasa Reddy
Sent: 26 July 2007 15:24
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
<mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal XI and Left OuterJoin
Anytime I use a left outer join I get a "Failed to retrieve data from
the database" message.
Anyone have issues with this? Is there a fix for it? If so where do I
get it?
TIA,
M. Manasa Reddy
ERP / Inventory & Procurement Manager
Welding Company of America
manasa@... <mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
<mailto:manasa%40weldcoa.com>
P: 630-806-2000
F: 630-806-2001
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]
[Non-text portions of this message have been removed]