Date Issue, Can't get Dynamic Value

[kyjoey]

Hey everyone,

I have an issue with a report being built in MS Reporting Services. I need the following statement to be dynamic for the date at the end, and I am not sure how to do so.

(SELECT SUM(TotAmount) FROM tblGiftData GROUP BY YEAR(OrderDate) HAVING (NOT (YEAR(OrderDate) IS NULL) AND YEAR(OrderDate) = 2006))

This cannot be a parameter because it will have to be generated for many different years. Any assistance would be great!

Thanks!

-Joey

 

[r937]

select sum(TotAmount) 
  from tblGiftData 
 [b]where[/b] year(OrderDate) = year(getdate())

r937.com | rudy.ca