Hi I am trying to give a count of participants but the number is not correct I dont know what I am doing wrong. I am using Reporting Services 2005. =count(Fields!ParentId.Value) is what I use but its not correct, is there something I am doing wrong? For example I have parameters on the report so when I do a range of 04/26/11 to 04/26/11 the total number of participants that got hours that day is a total of 14 but the calculation is giving me 39 and I dont understand why. SELECT People_tbl.FirstName, People_tbl.LastName, People_tbl.Manzanita, People_tbl.[Parent ID], People_tbl.ServiceArea, TanfActivity_tbl.TypeofContact, TanfActivity_tbl.PurposeofContact, TanfActivity_tbl.ReferralDate, TanfActivity_tbl.Earnedhours, TanfActivity_tbl.Catagoryforhours, TanfActivity_tbl.ServicesCovered, TanfActivity_tbl.StateCatagory, TanfActivity_tbl.StateServicesCovered, TanfActivity_tbl.NameofWorkshop, TanfActivity_tbl.EventDate, TanfActivity_tbl.ID FROM People_tbl INNER JOIN TanfActivity_tbl ON People_tbl.[Parent ID] = TanfActivity_tbl.[Parent ID] WHERE (People_tbl.ServiceArea = N'San Diego') AND (TanfActivity_tbl.EventDate BETWEEN @Beginning_EventDate AND @End_EventDate) AND (People_tbl.Manzanita = N'No')

Could it be you are counting total number a participant appaers in the dataset, rather than counting them once you could try =countdistinct(Fields!ParentId.Value)

That work thank you so much