How To Set Dynamic Numeric Decimal Point In Crystal Report For SAP Business One

In Crystal Report For SAP Business One, we can set how numeric field value displayed according to the number value itself.
For example:
1. 1250.00 → will be displayed as 1250 (No decimal point)
2. 1250.65 → will be displayed as 1250.65

Step by step:

1. In Crystal Report Designer, right click on numeric field, for example DocTotal
   • 
2. In the Format Editor dialog box, click “Customize” button
   • 
3. In “Custom Style” dialog box, choose “Number”:
   • Click formula button beside “Decimals” setting, and insert formula below.
   • Do the same for “Rounding” setting formula.
   • 
4. Result will be displayed like this:
   • 

Also read:

• Authorizations for Custom Reports with the Crystal Reports in SAP Business One
• Using One Crystal Report Layout for A/R DP Request and A/R DP Invoice
• Create and Update Parameters SAP Crystal Reports