how to count distinct

yonhantdaenta89@hotmail.com

Hi All,

i want to ask how to count distinct a record in this case i want to make a report from it
take this for example.

i have 3 reecord
Mr x
Mr x
Mrs y

when i count that, the result of count will be 2. how can i get that. i've search this forum for a while but seems that the page was deleted or cannot be found again

thanks,

RockWithNAV

Hey,

If you are making your Report on NAV 2013 Or later, you may write this code.
CountDistinct(Fields!X.Value)

yonhantdaenta89@hotmail.com

Wow.

it solved. never think of that.

many thanks @RockWithNAV

RockWithNAV

Hey yonhantdaenta89,

Glad to hear this . Please verify the answer so that this thread gets closed and others may find the answer easily.