Search code examples
reporting-servicescalendarssrs-2008ssrs-tablixssrs-grouping

SSRS Report - Creating Calendar Style Report with Multiple Data in a Single Calendar Cell

I am trying to achieve calendar style report using this link :

http://msdyn.blogspot.com/2013/07/create-calendar-style-reports-in-sql.html

But this Calendar Style Report is for the Sum of Sales. enter image description here

enter image description here

My desired result of the report is to return a list of employees in a Calendar cell. But it returns redundant day numbers. I am seeking for advise on how to remove the redundancy of the day numbers (I want multiple employees in one calendar cell). (Screenshot below). Any suggestions please? Thank you in advance!

enter image description hereenter image description here

Solution

  • I ended up using a Sub-report in order to fix the issue.

    enter image description here