meichmann - Thursday, February 1, 2018 7:14 AM
At the moment, I've not logged on. So I'd suggest you the below,
Please group the table by week of Order date.
Create some aliases like
01/01/18 to 01/07/2018 as '01/01/18'
01/08/18 to 01/15/2018 as '01/08/18'
01/16/18 to 01/23/2018 as '01/16/08' ( date names are your wish)
Once you've developed the query, You can create SSRS report and a data driven subscription for that. This will satisfy your requirement.