COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nsaha on 01 Mar 2012 09:17:28 AM

Title: Not getting Desired Data in List
Post by: nsaha on 01 Mar 2012 09:17:28 AM
Hi All,
I need a help.

Today I faced a problem.I have  put data items from different tables in a list.Then I got values only for those data items whose values are available in two or three data subjects because of inner join.But I want to get also those data(it will be 0 of course because the data is not available in all data subjects) which have no matching values in other tables.So how can we show that???
Title: Re: Not getting Desired Data in List
Post by: HalfBloodPrince on 01 Mar 2012 11:56:52 PM
You need outer Join.