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?
When you set aggregate to none then Cognos will switch to a select distinct (which is standard behavior when only identifiers and attributes are fetched)
To avoid this you have to set at query level automatic grouping and ...... to 'no'
(No exact indication, cause I have only the dutch version available)
edit:
On second thought, there should be a transaction number or whatever that distinguishs the similar rows. If you fetch that as well, then you'll have you're 2 lines.
Sounds like you need to either bring in another item which makes the rows unique (as the per previous post) even if you then hide it in the query or change the automatic group and sum property for the query
And probably turn off Auto-Aggregation in the report query the list object is based on.