title: String aggregation in SSRS 2005
body: <p>Using BIDS 2005 to create rdl reports.  I want to have the report aggregate all the strings in a data group.  I was looking for something along the lines of Concatenate(Fields!CompanyName.Value, ","), or Join, or equivalent.  But it would have to iterate over all the records in the scope given.</p>
  
  <p>I am creating a report of a user's activities in a calendar format (looking like the google's month view calendar)  But if a user has multiple activities on a single day I want all of them to show up in the same 'day box'.  Is this a problem needing aggregation or is there some other way to get a SSRS report to do this, I have tried to figure a way to get the matrix to do it for me but I am hitting walls.</p>