• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 128
  • Last Modified:

Crystal Reports - How to Set Default Join Type to Left Outer Join

Is there a way to get Crystal Reports to default to using a left outer join when linking tables?  By default, it always uses an inner join.  I have to click on each link, select Link Options, and then change the join type.  If I forget even one of them, then the output is not correct.

If there is not a way to default the join type, is there a way to select all of the links and change them all at once?  If I select more than one of them, it only changes the join type for the first one that I selected.
0
Brian Pringle
Asked:
Brian Pringle
  • 2
1 Solution
 
mlmccCommented:
As far as I know there is no way to set the default join type.

Are you using SMART LINKING to join the tables?
If so you should turn that off and manually link the tables.
I have found in most cases smart linking either adds too many joins or joins too many tables

mlmcc
0
 
Brian PringleSystems Analyst II, SCM, ERPAuthor Commented:
I manually clear all of the links and manually add them.  However, even with manually adding them, I still have to right-click each one and change the link options to left outer join.
0
 
mlmccCommented:
There is an option under FILE --> OPTIONS to turn off SMART LINKING.  Then you don't have to manually clear them.

As I stated before, I don't know of any way to change default to LEFT OUTER JOIN
0

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now