Phone
+62-877-8655-5055
+62 (21) 580-6055

Email
sales-enquiry@sterling-team.com

Address
Sampoerna Strategic Square
South Tower 18th
Jl Jend. Sudirman kav 45-46
Jakarta 12930 - Indonesia

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

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

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
    • SAP Business One Indonesia/dynamicdecimalRPT1
  2. In the Format Editor dialog box, click “Customize” button
    • SAP Business One Indonesia/dynamicdecimalRPT2
  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.
    • SAP Business One Indonesia/dynamicdecimalRPT3
  4. Result will be displayed like this:
    • SAP Business One Indonesia/dynamicdecimalRPT4