Solved

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

Posted on 2016-11-17
3
12 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
Comment Utility
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
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

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…
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…
This video explains how to create simple products associated to Magento configurable product and offers fast way of their generation with Store Manager for Magento tool.

744 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now