Crystal Report Number Field Formatting
-
Hello I have a column in crystal report which can display both float values as well as integer values... Using formatting i set the decimal notation as 000.000 it is working fine for float.. but for integer values also it displays decimal part (like 5.000) I want it to be displayed like an integer 5 Any options available in reports/?? Thanks in Advance...
Salai
-
Hello I have a column in crystal report which can display both float values as well as integer values... Using formatting i set the decimal notation as 000.000 it is working fine for float.. but for integer values also it displays decimal part (like 5.000) I want it to be displayed like an integer 5 Any options available in reports/?? Thanks in Advance...
Salai
You set a formula to the number of decimal places in number Custom Style dialog. In that formula you resolve if the number is integer or float. If it's an integer you return 0 (meaning no decimal places) and if it's a float you return 3 if you want three decimals. Another option is to create a new formula field and use type conversion functions etc such as CStr. Then place this field into the report.
The need to optimize rises from a bad design
-
You set a formula to the number of decimal places in number Custom Style dialog. In that formula you resolve if the number is integer or float. If it's an integer you return 0 (meaning no decimal places) and if it's a float you return 3 if you want three decimals. Another option is to create a new formula field and use type conversion functions etc such as CStr. Then place this field into the report.
The need to optimize rises from a bad design
Mika.... Thanks it worked fine... Thank you so much
Salai
-
Mika.... Thanks it worked fine... Thank you so much
Salai