reporting-servicessqlreportingservice

Reporting Services Horizintal calendar with monthly and weekly sum


I want to create a report that represents a horizonal calendar by the specified month. Data cells of matrix contains the work hours of the employees.

The problems just follow:

calendar representation

Thanks in advance!

UPDATE!

The answer below solve my main problem, the only problem is that, in the first data row is empty in all case. I think the empty row is displayed because not all days contain working hours and SSRS cannot group empty days, but i do not know what expression is the solution.

enter image description here


Solution

  • Assuming you have some sort of week number to group by...

    Add a Row group by Employee, ....looks like this is already done.

    For column groups, start with a group by date, then add a parent group with a header (right click your date group Add Parent, in the dialogue select your week number as the field to group on and select the include header option). Then add a total total group to the week number group to get your overall totals.

    If you need a more detailed answer let me know and provide some sample data to work with.