Using LEN, RIGHT, and LEFT

• Tek

  SSCommitted

  Points: 1697

  More actions

  June 9, 2011 at 10:19 am

  #238871

  Need some assistance here. I'm converting some Crystal reports to SSRS and I ran into a snag. In one of my reports, I have the following Crystal formula:

  if

  LEN({View_Report_LABELS.case_number}) = 15

  then

  LEFT(RIGHT({View_Report_LABELS.case_number},9),2)

  else

  RIGHT({View_Report_LABELS.case_number},2)

  I'm trying to translate this into SSRS, but having trouble with the syntax. Can anyone assist? Thank you.

• Dan.Humphries

  SSChampion

  Points: 12125

  More actions

  June 9, 2011 at 10:30 am

  #1336488

  Select

  case

  when LEN({View_Report_LABELS.case_number}) = 15

  then LEFT(RIGHT({View_Report_LABELS.case_number},9),2)

  else

  RIGHT({View_Report_LABELS.case_number},2)

  end

  Dan

  If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.

• Tek

  SSCommitted

  Points: 1697

  More actions

  June 9, 2011 at 10:32 am

  #1336494

  Awesome thanks. I've been creating too many reports lately, didnt think about making a case statement. Thanks!