Outer join - failed to retrieve data - progress

[da0]

I'm trying to create a crystal report. I've connected a progress database through a ODBC connection. So far so good. I use several tables on my report. Two tables has to be linked as type outer join. The two tables or budget and sales.
Everytime I run the report I get a message that no data can be retrieved. I do not encounter that problem when using a (standard) inner join.
I need an outer join because I want to compare the budgetted sales of each productgroup with the effective sales. So even if we have no sales in a certain month, I want to see the budget - sales information.

 

[synapsevampire]

If the ODBC driver doesn't support an outer join you'll need to use a subreport.

Or perhaps you can paste in the actual SQL in an Add Command, of course that depends on your Crystal version...

-k