How to get the outer join datas.

mohanaraj

Dear all,

I want to display the report with data from two table with relation.
In the first table the data columns present are

1. DepartmentId
2. Calls
3. cost
4. Duration

In the second table contains

1. DepartmentId.
2. Extension
3.Calls
4.Cost
5.Duration.

In this i create a relation between these two table by DepartmentId

I design the report as
In outer Data band i design the field with first table, and inner data band with second table
the report display only the data which matches the second table DepartmentId.
But i want to display both matched data and unmatched data. Ie

First Table fields
Second table fields
Second table fields
second table fields

First Table Fields

First Table Fields

First Table Fields

Now i getting
First Table fields
Second table fields
Second table fields
second table fields

AlexTZ

Hello,

Select the master data band and set its "PrintIfDetailEmpty" property to true.

mohanaraj

AlexTZ wrote: »

Hello,

Select the master data band and set its "PrintIfDetailEmpty" property to true.

Dear Alex,

Thank you very much.