Page footer and text box

• keywestfl9

  SSCertifiable

  Points: 5215

  More actions

  July 15, 2008 at 4:27 pm

  #189533

  i want to make textbox visibile and invisible based on a condition. how do i do it thru code in SSRS?

• nigel.c.west

  Hall of Fame

  Points: 3468

  More actions

  July 16, 2008 at 5:40 am

  #843695

  Go to the properties of the text box, open up the Visibility area and on the first item (Hidden) create an expression such as:

  =IIF(Fields!Country.Value="USA",TRUE,FALSE)

  The above will hide the text box if the country is USA for this row, so a return value of TRUE means hide it, and FALSE means show it.

  Good luck,

  Nigel West
  UK