BLANK SPACE

• cpinky01

  Ten Centuries

  Points: 1084

  More actions

  September 17, 2010 at 11:51 am

  #224176

  HI,

  IF THE VALUE IN A COLUMN IS 10 THEN THAT COLUMN HAS TO BE SHOWN BUT JUST BLANK.

  ELSE WHATEVER THA VALUE IS PRESENT.

  =IIF(Fields!Product.Value = 98, " ", Fields!Product.Value)

  BUT GIVING ERROR.

  CAN ANY ONE HELP ME WITH THIS?

• Doug Lane

  SSCrazy

  Points: 2118

  More actions

  September 17, 2010 at 2:04 pm

  #1223311

  You might be mixing data types. Try this:

  =IIF(Fields!Product.Value = 98, " ", CStr(Fields!Product.Value))

  A blank space can't be implicitly converted to an int.

• veeren4urs

  SSCrazy

  Points: 2763

  More actions

  September 22, 2010 at 1:47 am

  #1225366

  Hi ,

  Try the below one.

  =IIF(Cint(Fields!Product.Value) = 10, nothing , Fields!Product.Value)

  Thanks,

  Veeren.

  Thanks & Regards,
  Veeren.
  Ignore this if you feel i am Wrong. 😉