IIf statement!?

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  September 10, 2012 at 7:52 am

  #261301

  Hi people.

  I need to customize a textbox on my report:

  if the field value = 'True' then write 'Allowed'

  How do I write this IIf statement?

  Thanks

  Regards

• H4K

  Hall of Fame

  Points: 3374

  More actions

  September 11, 2012 at 3:31 am

  #1536084

  You can try following :

  1)Go to properties section of the textbox by selecting the textbox and pressing F4.

  2) Go to the Format section in properties.

  3) Click the drop down near the Format section and select Expression.

  4) Type the following expression in the expression window:

  =iif(value = 'True', "Allowed", "Not Allowed")

  Here 'value' is the textbox value at runtime.

  BI Developer
  SSRS, SSIS, SSAS, IBM Cognos, IBM Infosphere Cubing services, Crystal reports, IBM DB2, SQL Server, T-SQL
  Please visit... ApplyBI

• davdam8

  Hall of Fame

  Points: 3620

  More actions

  September 11, 2012 at 3:40 am

  #1536088

  Thanks. Works perfectly!

  Regards