Help with Expression

• GBeezy

  SSCarpal Tunnel

  Points: 4723

  More actions

  June 25, 2012 at 11:01 am

  #258042

  I am attempting to write an Expression in a Text Box to only show one value as like a header. There are 5 possible values and I plan to have 5 text boxes, with only one value in it.

  Textbox1 = "Initiation"

  TextBox2 = "Planning"

  TextBox3 = "Development"

  and so on...

  I am struggling to write this expression =First(Fields!Phase.Value, "DataSet") = "Initiation" is what I am attempting.

  Any help will be greatly appreciated.

• Ant-Green

  SSC Guru

  Points: 113507

  More actions

  June 26, 2012 at 2:17 am

  #1505448

  Sorry, it might just be me reading this but it doesnt seem very clear.

  How do you determine which value should go in which textbox?

  But it looks like you need nested IIF or a SWITCH