Currency into word in crystal reports or asp.net.

Question

Hi Experts,

I have one problem in Crystal report or asp.net.

when my total is 2455 then it display also in character like this,

Two thousand four hundred fifty five.

Thanks In advance,
CurrencyJitendra Patel

Vulpes · Answer

Further to my response to your article comment, here's my version for the Indian number system: using System; class Program { static void Main() { string input; int number; bool isValid; bool useAnd = false; Console.WriteLine("
Enter '0' to quit the program at any time
"); while (true) { Console.Write("
Use 'and' as separator y/n : "); input = Console.ReadLine(); if (!(input.ToLower() == "y" || input.ToLower() == "n")) Console.WriteLine("
 Must be 'y' or 'n', please try again
"); else { if (input.ToLower() == "y") useAnd = true; Console.WriteLine("
"); break; } } do { Console.Write("Enter integer : "); input = Console.ReadLine(); isValid = int.TryParse(input, out number); if (!isValid) Console.WriteLine("
 Not an integer, please try again
"); else Console.WriteLine("
 {0}
", NumberToText(number, useAnd)); } while (!(isValid && number == 0)); Console.WriteLine("
Program ended"); } public static string NumberToText(int number, bool useAnd) { if (number == 0) return "Zero"; string and = useAnd ? "and " : ""; // deals with using 'and' separator if (number == -2147483648) return "Minus Two Hundred " + and + "Fourteen Crore Seventy Four Lakh Eighty Three Thousand Six Hundred " + and +"Forty Eight"; int[] num = new int[4]; int first = 0; int u, h, t; System.Text.StringBuilder sb = new System.Text.StringBuilder(); if (number { sb.Append("Minus "); number = -number; } string[] words0 = {"" ,"One ", "Two ", "Three ", "Four ", "Five " ,"Six ", "Seven ", "Eight ", "Nine "}; string[] words1 = {"Ten ", "Eleven ", "Twelve ", "Thirteen ", "Fourteen ", "Fifteen ", "Sixteen ", "Seventeen ", "Eighteen ", "Nineteen "}; string[] words2 = {"Twenty ", "Thirty ", "Forty ", "Fifty ", "Sixty ", "Seventy ","Eighty ", "Ninety "}; string[] words3 = { "Thousand ", "Lakh ", "Crore " }; num[0] = number % 1000; // units num[1] = number / 1000; num[2] = number / 100000; num[1] = num[1] - 100 * num[2]; // thousands num[3] = number / 10000000; // crores num[2] = num[2] - 100 * num[3]; // lakhs for (int i = 3; i > 0; i--) { if (num[i] != 0) { first = i; break; } } for (int i = first; i >= 0; i--) { if (num[i] == 0) continue; u = num[i] % 10; // ones t = num[i] / 10; h = num[i] / 100; // hundreds t = t - 10 * h; // tens if (h > 0) sb.Append(words0[h] + "Hundred "); if (u > 0 || t > 0) { if (h > 0 || i if (t == 0) sb.Append(words0[u]); else if (t == 1) sb.Append(words1[u]); else sb.Append(words2[t - 2] + words0[u]); } if (i != 0) sb.Append(words3[i - 1]); } return sb.ToString().TrimEnd(); } } If you enter 'no' to using 'and' and then enter : 125480, it should return: One Lakh Twenty Five Thousand Four Hundred Eighty

Vulpes · Answer

Thanks, Suthish :) Might do a quick article now that point has been confirmed. It does seem a strange term but I found it mentioned in this Wikipedia article ( http://en.wikipedia.org/wiki/Indian_numbering_system ) in case you're wondering where I've got it from.

Suthish Nair · Answer

yes its 1 billion = 100 crores. but Arab - relating to Arabia and the people of Arabia.

Vulpes · Answer

Jitendra and Suthish, In India today, for one billion, would you say it was commoner to use 100 crore or one arab? When I wrote this program, I was told that the term 'arab' was seldom used but I wondered whether you agreed with that?

Jitendra Patel · Answer

Hello Dear, Thanks a lots. I shell never forget you kindness. Thank u very much for share you knowledge. Keep it up,

Jitendra Patel · Answer

Dear All, I got the Solution but it is work only in Sqlserver 2008 and 2005 Not work in 2000................. If any idea to work in 2000 please help me... My database in sqlserver 2000.

Jitendra Patel · Answer

Hello, Enjoy this function it is work perfectly, USE [Test] GO /****** Object: UserDefinedFunction [dbo].[fnNumberToWords] Script Date: 05/02/2011 15:47:04 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO ALTER FUNCTION [dbo].[fnNumberToWords](@Number as BIGINT) RETURNS VARCHAR(1024) AS BEGIN DECLARE @Below20 TABLE (ID int identity(0,1), Word varchar(32)) DECLARE @Below100 TABLE (ID int identity(2,1), Word varchar(32)) INSERT @Below20 (Word) VALUES ( 'Zero'), ('One'),( 'Two' ), ( 'Three'), ( 'Four' ), ( 'Five' ), ( 'Six' ), ( 'Seven' ), ( 'Eight'), ( 'Nine'), ( 'Ten'), ( 'Eleven' ), ( 'Twelve' ), ( 'Thirteen' ), ( 'Fourteen'), ( 'Fifteen' ), ('Sixteen' ), ( 'Seventeen'), ('Eighteen' ), ( 'Nineteen' ) INSERT @Below100 VALUES ('Twenty'), ('Thirty'),('Forty'), ('Fifty'), ('Sixty'), ('Seventy'), ('Eighty'), ('Ninety') DECLARE @English varchar(1024) = ( SELECT Case WHEN @Number = 0 THEN '' WHEN @Number BETWEEN 1 AND 19 THEN (SELECT Word FROM @Below20 WHERE ID=@Number) WHEN @Number BETWEEN 20 AND 99 THEN (SELECT Word FROM @Below100 WHERE ID=@Number/10)+ '-' + dbo.fnNumberToWords( @Number % 10) WHEN @Number BETWEEN 100 AND 999 THEN (dbo.fnNumberToWords( @Number / 100))+' Hundred '+ dbo.fnNumberToWords( @Number % 100) WHEN @Number BETWEEN 1000 AND 99999 THEN (dbo.fnNumberToWords( @Number / 1000))+' Thousand '+ dbo.fnNumberToWords( @Number % 1000) WHEN @Number BETWEEN 100000 AND 999999 THEN (dbo.fnNumberToWords( @Number / 100000))+' Lakh '+ dbo.fnNumberToWords( @Number % 100000) WHEN @Number BETWEEN 1000000 AND 9999999 THEN (dbo.fnNumberToWords( @Number / 1000000))+' Cr. '+ dbo.fnNumberToWords( @Number % 1000000) ELSE ' INVALID INPUT' END ) SELECT @English = RTRIM(@English) SELECT @English = RTRIM(LEFT(@English,len(@English)-1)) WHERE RIGHT(@English,1)='-' RETURN (@English) END

Vulpes · Answer

I'm not sure whether it will help in your particular scenario but check out my article on converting numbers to words ( http://www.c-sharpcorner.com/UploadFile/b942f9/6362/?ArticleID=0910264a-898f-49be-84b5-38b5b5f83a15 ). I also have a version for the Indian number system (lakhs, crores), which I can dig out if you need it.

Jitendra Patel · Answer

Hello Suthish, Above my post(function) is not working perfectly. So, please give me a solution. Thanks In Advance, Jitendra Patel

Suthish Nair · Answer

Ok, did you followed the links i posted for permanent solutions?

Jitendra Patel · Answer

Hello All, I have solved my problem but not in crystal report or asp.net. I have create function in SQL Server. please refer below link.... http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=86067 I have temparory solved this problem not perment. Thanks, Jitendra

Suthish Nair · Answer

There is no direct way. refer links.. 1 , 2

Currency into word in crystal reports or asp.net.

Answers (12)