Expressions to convert ID Value to a Name Value

• Papi_1981

  Old Hand

  Points: 315

  More actions

  March 16, 2011 at 5:37 pm

  #235343

  Hi All,

  I have a dataset which is returns a few Priority Ids, i.e 1,2,3,4

  What is the best expression function used to convert these Priorty values to Names

  i.e

  If Priority ID = 1, display ‘Low’

  If Priority ID = 2, display ‘Medium

  If Priority ID = 3, display ‘High

  If Priority ID = 4, display ‘Critical

  Would the IFF statement allow multiple conditions?

  Regards,

  Robbie

• Papi_1981

  Old Hand

  Points: 315

  More actions

  March 16, 2011 at 5:44 pm

  #1299731

  Found this:

  Switch

  (Fields!Priority.Value= 1,"1-Critical",

  Fields!Priority.Value= 2,"2-High",

  Fields!Priority.Value= 3,"3-Medium",

  Fields!Priority.Value= 4,"4-Low",

  Fields!Priority.Value= 5,"5-Question")