I'm working on report in SSRS , As you see in the Screenshots, i have 2 rows with same name "Bornholm",where one of them contains 1 person "Rasmus ..." and the another one contains 6 person , BUT that's not what i want . I just wanna One "Bornholm" ,where contains 7 person (plus Rasmus) ,i also checked the main query for this,its look like fine and i also used DISTINCT in my query but nothing happens in my table ,Can someone please point me in the right direction?
What I have tried:
i also checked the main query for this,its look like fine and i also used DISTANCE in my query but nothing happens in my table