How do I create a report that will show 4 columns, one per week, with data summed by week RRS feed

  • Question

  • I am new to SQL Report Builder and I am trying to build a report by Driver that will sum in 4 columns for the 4 weeks, Driver miles by week.
    Wednesday, November 13, 2019 6:12 PM

All replies

  • Use the table wizard by going to menu -> Insert-> Table Wizard.
    Choose your connection and database (table)

    In column group drag the column week and in values the same thing

    Fabiano Carvalho

    Wednesday, November 13, 2019 6:28 PM
  • The issue is that in our database the weeks are not numbered, but there are dates. Can I use the SQL code like

    =Dateadd("d",-7,Today()) as part of an expression to get a range?

    Wednesday, November 13, 2019 9:02 PM
  • Hi Sackie,

    In SSRS expression, DataAdd function is kind like the DateAdd in SQL.

    You could check the official doc for this :DateAdd function



    MSDN Community Support Please remember to click Mark as Answer; the responses that resolved your issue, and to click Unmark as Answer if not. This can be beneficial to other community members reading this thread. If you have any compliments or complaints to MSDN Support, feel free to contact

    Thursday, November 14, 2019 7:16 AM