?
Solved

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

Posted on 2016-11-17
3
Medium Priority
?
86 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 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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

On Demand Webinar: Networking for the Cloud Era

Ready to improve network connectivity? Watch this webinar to learn how SD-WANs and a one-click instant connect tool can boost provisions, deployment, and management of your cloud connection.

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…
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

762 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