Empty Report

[kellog1]

Hi,
I have problem creating a report using 3 tables A,B and C. The relationship between A and B is 1 to 1..between A and C is 1 to many but I dont have any relationship between B and C. There are no common keys to create relationship between B and C. Now when grab columns either from A,B or A,C I get the values in the report, but when I insert columns from all the 3 tables ..the report turns out be blank no values are returned.

Please help me fix this problem.


Thanks

Kris

 

[GJParker]

change your join types between and A and B and A and C to Outer Joins

HTH

Gary Parker
MIS Data Analyst
Manchester, England

 

[kellog1]

Thanks Gary ..that helped me.