COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Nithesh UC on 12 Apr 2013 05:50:24 AM

Title: View tabluar data issue
Post by: Nithesh UC on 12 Apr 2013 05:50:24 AM
Hi guys,

I have an issue where i can able to get all the values of a particular column when i see the View tabluar data.
But, when i drag the same column to the report layout many of the values of that column are not displaying.
I didn't applied any agrregations on that column.

Any suggestions or alternatives are appreciated.

Chill,
uC
Title: Re: View tabluar data issue
Post by: Lynn on 12 Apr 2013 09:53:42 AM
Is the query set to auto group and summarize? If the aggregations are the default it may still be aggregating based on settings in FM. Or it may be doing a select distinct if auto group is summarize is set to yes (the default).