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
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
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
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.