Click here to Skip to main content
15,908,111 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have string field in formula
{Expenses.Year}
this is giving output as 20,12.00 BUT i want like 2012
Posted

1 solution

To remove decimals,
Removing decimals in crystal reports, using cstr or ToText[^]
To remove thousand separator,
Uncheck Thousands Separator symbol[^] & also check this answer Avoiding thousand separator in Crystal Report Field[^]
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900