Search code examples
reporting-servicesssrs-tablix

SSRS - Group by week

I have a report that displays work hours from a start date parameter to an end date parameter. I'm struggling grouping the dates of the work hours by week. Below is a screenshot of how my report currently looks like:

enter image description here

How can I group the dates by week? In other words, how can I divide the above list into two, from 12/7/2020 - 12/11/2020 and 12/14/2020 - 12/18/2020? I already tried grouping by =DatePart("ww", Fields!EntryDate.Value) but then it only displays the first day of that week.

Edit: Even if I add a field that contains the week number of the EntryDate via SQL and group by that value, I only get the first date of the week.

As requested, here is the design of the report with its fields and a mock up of the final designing that I want to achieve.

enter image description here

Solution

  • Right-click the DateEntry group and add a parent group, include totals.

    Set the group expression to the calculated week number expression you already tried.

    If you still have week grouping in any other row groups, remove these. That should get you close