COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: nfldbunker on 28 May 2009 12:21:07 PM

Title: Duplicates in report
Post by: nfldbunker on 28 May 2009 12:21:07 PM
hi everyone

Hopefully this is only a minor issue in my report in report studio. I have a list report created based on criteria in a prompt page. When the report is executed i get all my data which is grouped over a number of columns.

name  acc#   dept   type  age  etc....

joe     111     fin      casual 50
                                     50
                                     50
fred    222     abc    perm   35
                                     35

the age is reating for each of the rows and i oly want to show this once

ANy ideas

shawn
Title: Re: Duplicates in report
Post by: Gopinath on 29 May 2009 01:59:49 AM
Set the Group Span property of the AGE field to the lowest group (Type in ur example)