Hi all (sorry french = mother-tong),

I have a big problem here with Cognos Impromptu 7. I am building Cognos
reports whichs are merging two or more other reports (under-reports).
What I can't succeed in doing about this is to do outer join beetween
those under-reports in the main report.

to do equi join no problem :
..imr n°1
my_key_1
sum(my_field)

..imr n°2
my_key_2
sum(my_other_field)

main .imr
select all the four fields, filter on my_key_1 = my_key_2 and drop one
of the two my_kew column in the result.

but how to proceed to have all the my_key_1 items (with 0 displayed in
front of) if theyre are more numerous than my_key_2 items ???

thanks a lot

+