Solved

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

Posted on 2016-11-17
3
46 Views
Last Modified: 2016-11-17
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
Comment
Question by:Brian Pringle
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 41891644
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
 
LVL 16

Author Comment

by:Brian Pringle
ID: 41891703
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
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 41891867
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

Secure Your Active Directory - April 20, 2017

Active Directory plays a critical role in your company’s IT infrastructure and keeping it secure in today’s hacker-infested world is a must.
Microsoft published 300+ pages of guidance, but who has the time, money, and resources to implement? Register now to find an easier way.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

There have always been a lot of questions related to when Crystal Reports evaluates report components (such as formulas, summaries, cross-tabs, charts, to name a few examples). Crystal Reports uses a two-pass reporting process to provide greater …
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

733 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question