How to display only negative numbers in brackets on Crystal reports?

Viewed 29

In Crystal report I have Amount column in detail section on crystal report Like:

  Amount  
 -90083.89 
 -87653.70 
  10008.00 

Expected Result in Amount Column: Amount (90083.89) (87653.70)
10008.00

crystal report image as a reference

1 Answers

You can just set the format to brackets for negatives in the field formatting options, under Format Field, then Number > Customise > Negatives

screenshot

If you're formatting via code then you'll need to use an if statement.

Related