Left join and Right join

[Flupke]

In a Crystal 8.5 report, I go to Database => Visual linking expert. I right-click on a link and choose Options.
I want to make a left join or right join link, but the "SQL join type"-frame is greyed. I cannot change anything.
How can I make a left or right join between two tables?
My report is created through the wizzard "Find database File".

Many thanks and greetings from Brugge (Bruges - Belgium),

Michel

 

[RobbieB]

Are the two tables from the same datasource? The only time I've had this happen was when joining to tables from different datsources.

 

[dgillz]

Use ODBC to connect, not a native database connection, and this will be available.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"A fine is a tax for doing wrong. A tax is a fine for doing well.
" - unknown

 

[RobbieB]

Even using an ODBC connection with tables from two different data bases I have had this problem.