Hello All Garus,
I need function in report studio which eliminates duplicate values in report studio.
eg: I have a column
COLUMN XYZ
Values of this column are:
ABC
CDE
CDE
FGH
FGH
FGH
IJK
IJK
What I want is like
ABC
CDE
FGH
IJK
I hope it is clear if not please let me know
I need function which I can use to filter this duplicate values just like oracle function like "DISTINCT"
you could group them?
You can use distinct function to show the column.
~Vivek
If you fetch no facts from the database and your XYZ column is assigned as an attribute, then Cognos will automatically add a distinct clause to the SQL generated..
Thanks for your response
But its already grouped and distinct function is not work in this case.
I have outjoin to it in FM.
Quote from: blom0344 on 08 Sep 2008 03:01:41 AM
If you fetch no facts from the database and your XYZ column is assigned as an attribute, then Cognos will automatically add a distinct clause to the SQL generated..
trim the data item and then do distinct....give a shot!