Wendy,
I believe the nature of a subreport link is that it is a left outer join (meaning that if the records are not in the subreport, it won't stop the main report from showing the record that is being currently viewed. However, that subreport link would not give you the error you are describing.
As Shirley suggested, there is probably a fix for this. In my memory, you may need the outjoin.reg fix that changes some things in your registry for Crystal. It depends on your ODBC version as to which outjoin.reg you use. IF Shirley's solution doesn't help, we'll see what we can do.
Troy Funte
Liberty Electronics
I believe the nature of a subreport link is that it is a left outer join (meaning that if the records are not in the subreport, it won't stop the main report from showing the record that is being currently viewed. However, that subreport link would not give you the error you are describing.
As Shirley suggested, there is probably a fix for this. In my memory, you may need the outjoin.reg fix that changes some things in your registry for Crystal. It depends on your ODBC version as to which outjoin.reg you use. IF Shirley's solution doesn't help, we'll see what we can do.
Troy Funte
Liberty Electronics
----- Original Message -----
From: Wendy Bowen
To: vantage@yahoogroups.com
Sent: Wednesday, June 26, 2002 1:08 PM
Subject: [Vantage] crystal left outer join
Hi again everyone!
Is it possible to link a subreport with a left outer join? I'm getting a left outer join error when compiling my report. I believe I've deducted that the left outer join must be made in the subreport linking to the main report. Is this even possible?
Thanks!
Wendy Bowen
Network Administrator
Schmald Tool & Die, Inc.
Burton, Michigan
[Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/links
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
[Non-text portions of this message have been removed]