Solved

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

Posted on 2016-11-17
3
41 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
  • 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

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Suggested Solutions

Crystal Reports: 5 Tests for Top Performance It is complete, your masterpiece report.  Not only does it meet your customer’s expectations, it blows them out the water, all they want is beautifully summarised and displayed in a myriad of ways. …
I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Microsoft Active Directory, the widely used IT infrastructure, is known for its high risk of credential theft. The best way to test your Active Directory’s vulnerabilities to pass-the-ticket, pass-the-hash, privilege escalation, and malware attacks …
With Secure Portal Encryption, the recipient is sent a link to their email address directing them to the email laundry delivery page. From there, the recipient will be required to enter a user name and password to enter the page. Once the recipient …

829 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