Thanks you for your insight below86.  I believe I fail to mention I am using a Store Procedure and can not freely write a Text SQL in the report.  I...

Thank you MarkP and SSChampion.  I was thinking something in the same line as yours, and incorporated both ideas and came up with this:

Mid(Fields!Field.Value, 1, Len(Fields!Field.Value) - InStr(StrReverse(Fields!Field.Value), "("))

At first...