Expression - How Do I replace a value with another value [Answered] RSS

• • Reply
  bootzilla

  Member

  192 Points

  1127 Posts

  Expression - How Do I replace a value with another value

  Apr 10, 2013 11:31 AM|bootzilla|LINK

  I am using an expression where I want to replace the First(Fields!inv_str_cust_seq.Value) with First(Fields!inv_cust_seq.Value) if first value - First(Fields!inv_str_cust_seq.Value) is NULL. The code below I'm using doesn't seem to work. 

  =IIf(IsNothing(First(Fields!inv_str_cust_seq.Value)), First(Fields!inv_cust_seq.Value),First(Fields!inv_str_cust_seq.Value))

• • Reply
  bootzilla

  Member

  192 Points

  1127 Posts

  Re: Expression - How Do I replace a value with another value

  Apr 10, 2013 02:37 PM|bootzilla|LINK

  ANyone with any ideas on this.

• • Reply
  Abhi.ssrs

  Member

  220 Points

  64 Posts

  Re: Expression - How Do I replace a value with another value

  Apr 11, 2013 04:07 AM|Abhi.ssrs|LINK

  Hi,

  Your Expresiion is correct. Its just that SSRS behaves that way sometimes for null values. Try using Len( First(Fields!ddd...)) >0  instead of IsNothing. that shud work.

   

  Please mark as answer if this helps!

  Thanks!

  AB

• • Reply
  bootzilla

  Member

  192 Points

  1127 Posts

  Re: Expression - How Do I replace a value with another value

  Apr 11, 2013 09:04 AM|bootzilla|LINK

  I tried using LEN and it didn't work. I used this:

  =IIf(Len(First(Fields!inv_str_cust_seq.Value))=0, First(Fields!inv_cust_seq.Value),First(Fields!inv_str_cust_seq.Value))

• • Reply
  bootzilla

  Member

  192 Points

  1127 Posts

  Re: Expression - How Do I replace a value with another value

  Apr 11, 2013 10:39 AM|bootzilla|LINK

  I figured this out. I had to change the stored procedure to accept null values for this field.