Crystal Reports – Blank space before number fields

by

Problem

You’ve inserted a number field and left aligned only to notice that the output doesn’t align with other fields, such as text fields.

This annoying little space then becomes a formatting issue.

Crystal-BlankSpaceBeforeNumberField1

Solution

By default in Crystal Reports, number fields have a blank space at the start to allow the negative (minus) symbol to be displayed.

If you know your value will never be a negative you can remove the space by following these steps:

  1. Right-click on the field and select ‘Format Field’
  2. Crystal-BlankSpaceBeforeNumberField2
  3. Click on the ‘Customize’ button
  4. Crystal-BlankSpaceBeforeNumberField3
  5. Click on the drop down list next to ‘Negatives’ and select ‘None’
  6. Crystal-BlankSpaceBeforeNumberField4
  7. Click ‘OK’ and ‘OK’ again to save the changes.
  8. The number field number aligns with the other text (string) fields
  9. Crystal-BlankSpaceBeforeNumberField5