• meichmann - Thursday, February 1, 2018 7:14 AM

    Hello Everyone,
         I hope someone can help me out with this.  I have an order table that stores order information.

    Order Number

    Order Date

    1

    01/01/18

    2

    01/04/18

    3

    01/09/18

    4

    01/17/18

    5

    01/18/18

    What I need is to get total counts per week so the result would look like this:

    Week of

    Count

    01/01/08

    2

    01/08/18

    1

    01/15/18

    2


    I also need this to be date driven so the user can put in a start and end date.

    Thanks for all your help!! 🙂

    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.