I am using SSRS in Visual Studio 2008 and need to create a report that displays names on a calendar based on the dates pulled from the database. I would like the calendar to display a month at a time My query pulls data that looks like the following:
Name StartDate EndDate NumDays (Shows difference between Start and EndDate)
Tim 1/1/2000 1/1/2000 1
Bill 1/4/2000 1/6/2000 3
Tim 1/10/2000 1/11/2000 2
For my report, I would need a Calendar that displays "Tim" on 1/1, 1/10, and 1/11 and display "Bill" on 1/4, 1/5, 1/6.
Any advice would be greatly appreciated. Thanks in advanced!