Duplicate Records in Report Studio

[cbyrne]

Help i am very new to report studio.  I have created a basic list view report which is pulling data from a lot of tables plus i am trying to pull data from custom attribute fileds.

When i run the report i get a lot of duplicate records, i can briefly understand why this is happening but because i have a lot of fields i am having trouble locating which table is causing the problem.

I am currently outputting to excel and filtering only unique records as a workaround.

Can any body help me here so i can simply filter distinct records.

Many Thanks

Chris

[gskumar]

Hi,
      Check the package and go to business view and get a understanding from cotext expoler and check out whether u have applied Determinants as this avoid double counting.
Cheers,
GSK

[cbyrne]

Thanks GSK but i do not understand, what package? i am in report studio.  I have just been looking into the aggregate function to see if i can count distinct records but this does not seem to work. 

Many Thanks


Chris

[david.stachon]

I think what GSK means, is that this is actually not a problem/issue with Report Studio, but rather a problem with the "Framework Manager" model. You will want to tell your Cognos Adminstrator the behaviour you are seeing and ask him to fix it.