I am creating a report from ArcMap and I would like for the null value fields to be replaced with either a blank or a 0 , but only in the generated report not in the actual attribute field.

Is this possible and, if so, how would you do it?

1 Answer 1


you can make some computation using the report designer.

Open a report in the Report Designer.

From the Design Elements list, click TextBox and drag the element into position on the report layout.

Enter an expression in the Data Field area in the Element Properties grid. Expressions always begin with an equals (=) sign

In you case, the expression should be something like

=(condition) ? value_if_true : value_if_false

=(YourField == System.DBNull.Value) ? " " : YourField

=(YourField == System.DBNull.Value) ? 0 : YourField
  • Perfect, that is it!
    – ed.hank
    Dec 17, 2014 at 20:27

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.