CODEWITHSUNDEEP
crystal-reportsformatreport
Prabhakar Anand
Prabhakar Anand

Reputation: 7

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

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

Upvotes: 1

Views: 364

Answers (1)

bendataclear
bendataclear

Reputation: 3848

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.

Upvotes: 2

Related Questions