[bspear]

I am trying to change my table linking from one-to-one to a left outer join, however the choice areas are greyed out. In a previous thread I found the following help:

Originally Posted by RobertWild
When you are adding the tables in the wizard, chances are you have selected to 'Automatically' join the related tables.

You need to chance each of the join types from an "inner join" to a "Left Outer Join".

This can be done via The Database Expert, Links tab (Available as the first option under the 'Database' menu item).

Edit: If the radio buttons are greyed out, deselect the option to 'Return All Rows Before Joining'.

Unfortunately, I must be blind because I cannot find this option. Can anyone help me locate how to allow me to change the joins in a report when the join options are greyed out? Thank you so much!!
Bonnie

[DrewAllen]

Robert's suggestion is specifically for Crystal XI. It is not available in Crystal 8.5.

Drew

[bspear]

Thank you Drew! I suspected that was the issue, but was hoping someone might remember 8.5 and have an idea for me to try. Appreciate your quick response.
Bonnie