Filtering By Date Range - Want To Aggregate

Im trying to get the top 10 sales people by date range



my cutdown select statement for my dataset is as follows:


SELECT TOP 20 SaleDate,Consultant, State, Sum(Value) As Winbacks, UserID

FROM dbo.tbl_kpi_sales
GROUP BY Consultant, State, SaleDate, UserID
HAVING (SaleDate)>= @Param_StartDate and (sales.SaleDate)<= @Param_EndDate) AND State IN (@Param_State)
ORDER BY Winbacks Desc;



The problem im getting is that when a date range is entered by the user, the same representative might appear in the top 20 list afew times as they made the top sale for different days, I am wanting the select statement to add up the total sales for that representative for that date range and return him as a single entry...Because the sale date is in the select statement the group by clause separates these records, I cannot take the sale date out off the select because i need it to determine the date parameter for the reports



for example for date range - 1/3/2005 to 20/3/2005 get the top 20 reps Im currently getting



Name Value Date

Jim Brown 20 1/3/2005

Jim Brown 10 12/3/2005

Jim Brown 23 13/3/2005

Tom 10 12/3/2005

etc...till top 20



I am wanting the following output



Name Value

Jim Brown 53

Tom 10



Is there someway off doing this which still allows me to use a date range entered into report services