INNER JOINS x OUTER JOINS

rbuser

I am building a report that has 4 levels: Header, Detail, subdetail and
sub-subdetail. In the Data tab, in Report Builder v.7.2, I crerate 4 data
views for each of the levels, and connect them selecting the SECOND option
(supposely this is the LEFT OUTER join, isn't it?). Then, in the Design tab,
I put my header fields in the header band, and below them I create a
sub-report, linked to the Detail Data view (or pipeline). In this sub-report
i do the same thing, putting another sub-report in it, and so forth.

I have two major problems:

1) When I see the "magic sql" of one of the detail data views I always see a
INNER JOIN instead of an OUTER JOIN;

2) When I preview the report using a where clause on the HEADER which
returns ONLY ONE HEADER, it works great. However, if I remove the filtering
so it returns more than one header, the report prints the headers correctly,
but all the data from the other levels in the first page. After that, the
subsequent headers are printed with nothing underneath it.

Please, I really need your help on these issues.

Thanks.

- Gus