title: SSRS report to display Outlook type calendar - People x Days x Activities
body: <p>I am after a pattern/view/opinion/tip/weblink from an SSRS/SQL expert on how I might create a report that enables me to list something like the following:</p>
  
  <p>[----Person----]&nbsp; | [29-Sep-11] | [30-Sep-11] | [01-Oct-11] | [02-Oct-11]  | [03-Oct-11]... and so on...<br />
  Bob Bobertson  |&nbsp;&nbsp;  Activity A &nbsp; | &nbsp;&nbsp;Activity B&nbsp;&nbsp;&nbsp; |    ----Empty---   | &nbsp;&nbsp;Activity C&nbsp;&nbsp; | ---Empty--- |<br />
  Rob Robertson  | &nbsp; Activity D &nbsp; |&nbsp;&nbsp; Activity E&nbsp;&nbsp; | &nbsp;&nbsp; Activity F&nbsp;&nbsp; | &nbsp;&nbsp;Activity G&nbsp; | ---Empty--- |<br />
  ...and so on...</p>
  
  <p>Date columns are dynamic - example, 10 days on from today (rolling window report)<br />
  Person column is dynamic list based on a user collection<br />
  So the above table looks pretty simple, but theres an extra dimension/depth to it.
  I need to get the details for the Activity to create a link to it and style it in the report based on other flags.</p>
  
  <p>I'm currently stumped on how to structure my resultset, and then how to Group/Pivot the data into a report structure.</p>
  
  <p>Has anyone done similar before?</p>
  
  <p>I'm using CRM4.0 for records including Date, Person, ActivityTitle, Billable etc</p>
  
  <p>SSRS 2008 for the report building via VS2008 BI studio</p>