0

I have a field 'Clockin' which will display the Date and Time,Now i have some blank values in it.how can make blank values to 'NA'?

SqlLearner
  • 763
  • 8
  • 23
  • 37

1 Answers1

1

You can do this by using a formula for the Value property to check if it is blank:

=IIF(IsNothing(Fields!Clockin.Value), "NA", Fields!Clockin.Value)
Chris Latta
  • 20,316
  • 4
  • 62
  • 70