Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

More than 1 outer join per table?

Status
Not open for further replies.

MattMiller

Programmer
Sep 12, 2003
6
0
0
US
We currently have a report making use of a nested report for one field.
This report needs to be exported to EXCEL and the nested report field does
not export. I created a view to extract the appropriate data. In order
for this view to work properly with this report, we need to use left outer
joins to 2 different tables. Is there a way to avoid the error message
that a table can only be outer joined to one other table?

I suppose this may be why the report was initially created using a nested
report, but I would really like to get around this.
 
This is not a Crystal error, but a database or ODBC error. What is your database and how are you connecting. What does the error window say at the top.

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Tips and Tricks / Guide to Crystal in VB
- tek@kenhamady.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top