Click here to Skip to main content
11,496,146 members (712 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: C#
Hi.. to all
I've created one crystal report and one crystal report viewer in .aspx page
I've connected to the database using database expert..
now i want to display total no of salary in 22,22,22,222.00
but it is displaying in this format 222,222,222.00
please help me.. and i want to display in words also.
i.e two crore two lakhs twenty two thousand two hundred and twenty two only..
Its urgent..


Removed pre tags with text
Posted 19-Sep-10 19:35pm
Edited 19-Sep-10 19:40pm
Abhinav S397.6K
v2

1 solution

I think the specific format you could not get in Crystal Report,
But there is a way to Accomplish by code Behind,

1. Number format you can take number as a String and Add ',' after every two digits and Fill it to Data Table and Bind this Table to Crystal Report and Care it as a String Rather then Number

2. Number in Words,
For that you can take reference of my Article which is well explained regarding this.
http://www.codeproject.com/KB/cs/Converter.asp[^]
  Permalink  

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

  Print Answers RSS
0 RyanDev 230
1 Sergey Alexandrovich Kryukov 114
2 Richard Deeming 100
3 OriginalGriff 89
4 Mostafa Asaduzzaman 59
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600


Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 20 Sep 2010
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100