• here is a good link http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=47307

    Once you get the first day of the week add no of days to that with the dateadd function to get the last day of your report.