I have a column in the detail section of the report that flags the rows that meet certain criteria (example: "start date < currentdate"). In the group footer, I need to print the key value of the rows that got flagged or that met the criteria (example: 3557 Olson, 6593 Kent). If I were doing the report in Crystal, I would create a shared variable that would accumulate the values as the rows were processed. I don't know how to do a similar function in SSRS. I wondered about RunningValue or Join but don't think these really apply to this situation.
Example of group contents with last column being the "flag" that indicates rows needing to be in list and the last line in the example being the "running list" I need to return:
2959 Grant 7/20/09 0
3557 Olson 9/15/08 1
3558 Jones 10/30/08 0
6593 Kent 8/15/08 1
6700 Tombs 12/1/08 0
MN Starts = 3557 Olson, 6593 Kent