List with Count (i think)

i have bunch of people in list column in same list has birthdays. need create report states following.

under 40
40-45
45-50
50-55
55-60
on 60

need know how many, based on birthdays, people fit different categories. life of me, cannot figure out how this. advice appreciated.

---

bm

you can use datediff function age in years:

=datediff(dateinterval.year,fields!birthday.value,today())

then use count number in each group:

=sum(iif(datediff(dateinterval.year,fields!birthday.value,today())<40,1,0) < gets count of people under 40

for categories high , low limit need specify both criteria joined and:

=sum(iif(datediff(dateinterval.year,fields!birthday.value,today())>39 , datediff(dateinterval.year,fields!birthday.value,today())<45,1,0) < gets count of people age 40 through 44

SQL Server  >  SQL Server Reporting Services, Power View