Hi  All,

Need your help for the below query

i am trying to create SSRS report using Fetch xml but getting duplicate value(column Identity Number) when group(Group properties from SSRS)

Expectation :

Employee number Employee names Identity type Identity number
1234 David B 8855
I

 

Result i am getting which is wrong

Employee number Employee names Identity type Identity number
1234 David B 8855
I 8855

Can you please help me to resolve this.

Thanks

Kumar