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:
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.
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.