OK, so TSQL windowing functions are out of the picture unfortunately.

Although still perfectly possible in TSQL, you can calculate a YTD in SSRS itself:

Cumulative Aggregates in SQL Server Reporting Services[/url]