Left Outer Join?

[gbr]

Hi,

I am programming with Visual Studio .Net 2003 and the included Crystal Reports.
I'd like to show the content of many joined tables, but if there is one primary key, that does not exists in the joined table the rowset is not displayed. When I examine the SQL query I can see that only inner joins are done by CR. How can I process outer joins, I found no menu item for this...

Kind regards,
gbr

[deebsj]

Hi ,
In CR 9, you have a database tab in main menu, under this you have a database expert option. Here you will see the tables that you have used in your report. In the database expert dialogue box you have 2 tabs- data and links. In this links tab you can set the outer joins as desired. By default the coulmns common to your tables will be linked. select a link and then click the link options, here you can set the various link types.

[gbr]

Yes, I found the menu you descibed. The option that processes a left outer join is called "left inclusion".

Thank you.