Click here to Skip to main content
15,881,033 members
Please Sign up or sign in to vote.
1.44/5 (2 votes)
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
Posted
Updated 26-May-23 1:59am
v3

1 solution

Please refer
[^]
 
Share this answer
 
Comments
Man Down 15-Mar-17 5:36am    
tnx

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900