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

Question

How to show amount Textbox Values in words in rdlc report

Rafnas T P · 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

Rafnas T P · Answer

try this for sql http://www.sqlservercentral.com/scripts/function/65640/

Jyoti Jodha · Answer

we Need in rdlc report not in Console program

Rafnas T P · Answer

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/

Sundaram Subramanian · Answer

Follow the steps in RDLC and apply the code already given. In report designer open "property" window then "code" tab.

Jyoti Jodha · Answer

Not crystal report we Need in rdlc report

Sundaram Subramanian · Answer

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 ';