SSRS Regex Expression for SharePoint Lookup Column

Scenario

• You have a multi-select (multivalue) lookup field in your SQL Server Reporting Services 2008 R2 report

Issue

• The field also displays the Field IDs and you want to format it correctly
• Ex: Value1;#5;#Value5;#6;#Value6

Resolution

• Use the following expression
• =System.Text.RegularExpressions.Regex.Replace(Fields!MyLookupColumn.Value, ";#\d+;#", ", ")