Click here to Skip to main content
15,896,606 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
how to display value 123456 value in the 1,23,456 fromat in Crystal report
Posted

1 solution

One option is to use formula fields as given here
http://khanrahim.wordpress.com/2011/04/25/customized-thousand-separator-in-crystal-report/[^]

Second option is set the current culture to a culture with above system of comma separation say hi-IN (please check the format in Crystal Reports) to the Crystal Report

C#
CrystalDecisions.Shared.SharedUtils.RequestLcid = "Country Code";

please check the above from your Crystal Reports documentation to set the current culture.
I do not have Crystal Reports to test.
In the crystal report set the thousand separator as shown here
http://support.insightdirect.com/help/cr/frmtnumcr.htm[^]
I think this may work. But please try.
 
Share this answer
 
v2

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