problems with outer joins in views in cr 9

[QMarkP]

Hi there,

i got a very serious problem:

crystal reports 9 Developer Edition
DB/2 7.2

when i try to use a view with a outer join i got no rows in the field explorer (no [+] sign at the data source (name of view)).

this is no general problem with outer joins because some other views using outer joins work fine.

trying to use the view without cr, directly -> the view works fine. try verifiy database causes a message like:
the database table ... could not be found. remove table ? yes | no.

SQL of the view:
CREATE VIEW VIEW_RPT_ROOS_UEB_ABT_DETAIL AS
SELECT kn.DIREKTION_NAME,
kn.DIREKTION_ID,
kn.BEREICH_NAME,
kn.BEREICH_ID,
kn.KST_KSTNR,
kn.KST_ID,
kn.ABT_kz,
kn.ABT_ID,
'AbtDetail' AS kosten_typ_name,
0 AS jahr,
0 AS plan_wert,
0 AS PLANTITEL_ID,
'' AS PLANTITEL_NAME,
0 AS PLANTITEL_NACHRICHT_JN,
kn.kosten_id,
ko.kosten_nummer,
ko.kosten_titel,
ko.kosten_wert,
ko.kosten_abgrenzwert,
kes.ke_status_id,
kes.ke_status_bezeichnung,
re.rech_wert,
re.rech_abg_betrag,
re.rech_dat,
re.rech_nummer,
re.rech_anmerkung,
li.lief_name
FROM view_kosten_kontierung_name AS kn,
tab_kosten AS ko LEFT OUTER JOIN tab_rech AS re ON ko.kosten_id = re.rech_kosten_id,
tab_lief AS li,
tab_ke_status AS kes,
tab_kosten_typ AS kty
WHERE ko.kosten_lief_id = li.lief_id
AND ko.kosten_ke_status_id = kes.ke_status_id
AND ko.kosten_id = kn.kosten_id
AND ko.kosten_kosten_typ_id = kty.kosten_typ_id
AND kty.kosten_typ_name = 'Personal DS';


some ideas ? thanks in advance, qmarkp