How to show amount in words in rdlc report in c#

Jyoti Jodha

9y9.4kWindows Forms

How to show amount Textbox Values in words in rdlc report

7 Replies

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

Rafnas T P9y ago
Accepted answer
or try this

https://forums.asp.net/t/1995435.aspx?How+to+convert+Number+to+word+using+Sql+Query+with+standard+US+as+UK+Fromat

in this
this will convert and give round value like
if 50.55 = fifty one
50.40=fifty
0
Rafnas T P9y ago
try this for sql

http://www.sqlservercentral.com/scripts/function/65640/
0
Jyoti Jodha9y ago
we Need in
rdlc report

not in Console program
0
Rafnas T P9y ago
I have a Article for converting number into word, but tthis is from c#, if you want just pass your amount value into this and save someware in table and you can display it in rdlc
link is given below

http://www.c-sharpcorner.com/article/convert-numeric-value-into-words-currency-in-c-sharp/
0
Sundaram Subramanian9y ago
Follow the steps in RDLC and apply the code already given.

In report designer open "property" window then "code" tab.
0
Jyoti Jodha9y ago
Not crystal report

we Need in
rdlc report
0
Sundaram Subramanian9y ago
Follow the steps:
1) right click on your formula field In crystal report viewer
2) click edit formula
3) formula workshop window will open
4) left side of the window u have 'report custom functions'
5)right click and select new
6)give the name for function
7) and the right top you have a drop down. it shows 'Crystal Syntax' as default
8)change this to basic syntax.
9) save the function.

You can use ToWords() Function in Your Crystal Report...

e.g.
currencyvar tt;
currencyvar dect;
tt :=100.30;
dect := tt - Truncate(tt);
tt := truncate(tt);
dect := dect * 100;
if dect = 0 then
'Rupees ' + ToWords (tt,0 ) + ' Only'
else
'Rupees ' + ToWords (tt,0) + ' And Paisa ' + ToWords(dect,0) + ' Only ';
0