Resources For IT Professionals
Post an article
Wikis - Page Details
  • First published by (5Microsoft Partner, Microsoft Community Contributo)
  • When: 4 Jun 2013 12:21 PM
  • Last revision by (8Microsoft Community Contributo)
  • When: 27 Jul 2013 10:30 PM
  • Revisions: 5
  • Comments: 2
Options
RSSSubscribe to Article (RSS)
Can You Improve This Article?
Positively! Click Sign In to add the tip, solution, correction or comment that will help other users.

Report inappropriate content using these instructions.
Wiki  >  TechNet Articles  >  Concatenating Data Column Values Into a Single String

Concatenating Data Column Values Into a Single String

Concatenating Data Column Values Into a Single String

The Request
My dataset returns multiple rows of data for a given grouping with only one field (we will call it Grade) varying across those rows. I want my report to display a single line for a group with all of the values of Grade for that group displayed as a concatenated string in a single cell of each group row.

The Solution
I did a similar thing in a report using TFS data. My grouping was by backlog item, each having 1 or more tasks, resulting in one row per task. My approach required custom code. I added the below custom code to the code module for the report:

 

Private Num As String = ""  
Private tempstr As String = ""   
Function AggregateString(Group as String, Val as String)   
If Group = Num   
Then tempstr = tempstr + ", " + Val  
Else Num = Group tempstr = Val   
End  
If   
Return tempStr   
End Function


Then, in the cell where the aggregated string will appear I added a formula similar to the below. I have modified it to reflect your fields:

=IIf(IsNothing(Fields!Grade.Value),"",RunningValue(Code.AggregateString
(Fields!GroupUniqueID.Value,CStr(Fields!Grade.Value)),Max,"GroupScope"))
, , , , , [Edit tags]
Leave a Comment
  • Please add 5 and 5 and type the answer here:
  • Post
Wiki - Revision Comment List(Revision Comment)
Sort by: Published Date | Most Recent | Most Useful
Comments
  • 27 Jul 2013 10:30 PM

    SathyanarrayananS edited Revision 3. Comment: Formatted code block

Page 1 of 1 (1 items)
Wikis - Comment List
Sort by: Published Date | Most Recent | Most Useful
Posting comments is temporarily disabled until 10:00am PST on Saturday, December 14th. Thank you for your patience.
Comments
Page 1 of 1 (2 items)