Currency into word in crystal reports or asp.net.

Jitendra Patel

15y4.3k.NET

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

12 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes15y ago
Accepted 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("\nEnter '0' to quit the program at any time\n");

while (true)
{
Console.Write("\nUse 'and' as separator y/n : ");
input = Console.ReadLine();
if (!(input.ToLower() == "y" || input.ToLower() == "n"))
Console.WriteLine("\n Must be 'y' or 'n', please try again\n");
else
{
if (input.ToLower() == "y") useAnd = true;
Console.WriteLine("\n");
break;
}
}

do
{
Console.Write("Enter integer : ");
input = Console.ReadLine();
isValid = int.TryParse(input, out number);
if (!isValid)
Console.WriteLine("\n Not an integer, please try again\n");
else
Console.WriteLine("\n {0}\n", NumberToText(number, useAnd));
}
while (!(isValid && number == 0));

Console.WriteLine("\nProgram 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 < 0)
{
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 < first) sb.Append(and);

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
Vulpes15y ago
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 Nair15y ago
yes its 1 billion = 100 crores. but Arab - relating to Arabia and the people of Arabia.
Vulpes15y ago
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 Patel15y ago
Hello Dear,

Thanks a lots.

I shell never forget you kindness.
Thank u very much for share you knowledge.

Keep it up,
Jitendra Patel15y ago
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 Patel15y ago
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
Vulpes15y ago
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 Patel15y ago
Hello Suthish,

Above my post(function) is not working perfectly.
So, please give me a solution.

Thanks In Advance,
Jitendra Patel
Suthish Nair15y ago
Ok, did you followed the links i posted for permanent solutions?
Jitendra Patel15y ago
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 Nair15y ago
There is no direct way. refer links.. 1, 2