I've created a report that displays a description of an account and it's balance. I've got the amount balance field formatted with @CX 999,999,999.99. The field is not left justified.

My problem is when I hit an account with a 0 balance. Because no DB/CR sign prints, the 0.00 is right justified and doesn't line up with the rest of the amounts in the column. For example:

  123,123.00 CR
    1,122.00 CR
           0.00
        3.00 DB

Is there any way to get the following:

  123,123.00 CR
    1,122.00 CR
        0.00
        3.00 DB

Thanks for your help.

Rodd