Grouping with Integer Field in SSRS

[M_nwadibia]

I have a stituation like this to group using Student ID in SSRS but when I do the grouping Student ID 1 is dupplicated as well as student ID 2. How Can I fix this?

[v-luwang-msft]

Hi  @M_nwadibia ,

Based on the data you provided, what is the output you would like to get?

Best Regards

Lucien

[M_nwadibia]

On student ID I want to see only 2 rows. The two rows will be 1 and 2 when grouped