I use the Over clause in this statememt to calculate tiered incentives (the more an employee sells, the more they earn)

DECLARE @TellerID as smallint

DECLARE @StartDate as smalldatetime

DECLARE @EndDate as smalldatetime

SET...

From my experience, after you add the report to the templates directory like htilburgs

explained, you can use the template within an existing project by doing an Add New...