I need to change the code so the report selects data 14 days before and 14 days after the selected date.

WHERE [DateColumn] BETWEEN DATEADD(days,-14,@DateParameter) AND DATEADD(days,14,@DateParameter)

not sure about the sequence of arguments in DATEADD, so you may need to check it... but that's the general idea, I think.