November 13, 2014 at 3:44 am
I have written an IIF statement:
=IIF(fields!addressline1.Value< ",", "No Details", Fields!addressline1.Value)
This works fine in that it returns 'no details' if the addressline1 value is blank. However, I would also like to add fields!postcode.value to the initial argument, something like:
=IIF(fields!addressline1.Value AND fields!postcode.value < ",", "No Details", Fields!addressline1.Value) - but this isn't working.
Any suggestions would be much appreciated - thanks.
November 13, 2014 at 9:51 am
Can't remember if the AND will work, you may need nested IIF functions, so one of these should work:
=IIF(fields!addressline1.Value < "," AND fields!postcode.value < ",", "No Details", Fields!addressline1.Value)
or
=IIF(fields!addressline1.Value < ",", IIF(fields!postcode.value < ",", "No Details", Fields!addressline1.Value), Fields!addressline1.Value)
November 13, 2014 at 3:20 pm
Option 1 worked well - thanks very much.
November 14, 2014 at 2:15 am
Great, no problem.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply