COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Report Studio => Topic started by: JulietBate on 03 Jun 2008 07:51:13 AM

Title: Only showing list row once if all fields show the same data - need all rows
Post by: JulietBate on 03 Jun 2008 07:51:13 AM
I have a number of transactions that I want to appear in a list report, where the values are exactly the same for each of the fields on the row, I am only seeing one of rows appear on my report.

Example: 
Account  Description     Amount
1234-12  Bank Interest  $20.15
1234-12  Bank Interest  $20.15

I want to see both lines on my report i.e. 2 x $20.15 but only see one line for $20.15 so my report totals are incorrect
I have set the aggregate function for each list column to be 'none' but this has not helped. What am I missing?
Title: Re: Only showing list row once if all fields show the same data - need all rows
Post by: Gopinath on 04 Jun 2008 05:48:51 AM
Set the Auto Group & Summarize Query property to 'NO'