If you are unable to create a new account, please email support@bspsoftware.com

 

Only showing list row once if all fields show the same data - need all rows

Started by JulietBate, 03 Jun 2008 08:15:19 AM

Previous topic - Next topic

JulietBate

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?

blom0344

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.

wyconian

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

rockytopmark

And probably turn off Auto-Aggregation in the report query the list object is based on.