
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