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