Multiple Left Outer Join Links - CR9

[reporter42]

General info first. I'm using CR 9, DataDirect ODBC Driver, Progress v9.1D database.

I've created a report that has multiple left outer joins. These tables are both linked from the far left table and no other tables are linked from them. I have a formula for each table that basically says

if isnull(field in table)
then
value
else
value

I can have one of those formulas on the report, but as soon as I place the other formula I get the following error:

Failed to open a rowset.
Details: HY000:[DataDirect][ODBC PROGRESS driver][PROGRESS]-20217

If I change the link from left outer to equal on one of the files, I can then place the other formula on the report without any problems, but then I lose records because not every customer in my database has a record on the file I changed the left outer join on.

I'm getting pretty desparate. I have to add another table and this one will also be a left outer with a formula with the same criteria.

I've tried everything that I can think of except doing a subreport for 2 of the tables that need to be left outer join. Not sure if it will work, but I'm at a loss as to what else to try.

I've looked at the Progress web-site, DataDirect web-site and the Crystal web-site to no avail.

Any help would be greatly appreciated.

Rhonda

 

[GJParker]

This thread may help thread149-899741

Gary Parker
MIS Data Analyst
Manchester, England

 

[reporter42]

Thanks. I should have mentioned though that I have already done this. I have verified it multiple times. I works fine with one left outer join, but as soon as you add another table, use that table in a formula and place that formula on the report, I get the error mentioned.

I was able to work around it by doing sub reports for the other tables that needed to be a LOJ but it has slowed down the report.