Expression

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  February 26, 2015 at 10:06 am

  #315685

  Can someone help me with an expression for this. I need to show the parameter label as this.

  Here is the SQL way , which works , Need to implement it thru an Expression but having no luck

  Select distinct Case when Program like '% , %' then REPLACE(Program ',','-') Else Program End as Program

  from dbo.Dept

• robert.gerald.taylor

  SSChampion

  Points: 13133

  More actions

  February 26, 2015 at 10:13 am

  #1780317

  I can't tell if that's a space and a comma, or a space, comma and space -- so tweak this to whatever you need:

  =Replace(Fields!YourStuff.Value, ", ", "-")

  HTH,

  Rob