Numbers to word text currency in Crystal Report
numbervar nAmount := 1000.99; numberVar nRemain:= Remainder(nAmount,1); numberVar IntAmount := Truncate(nAmount); stringVar sWordAmount:= ToWords(Truncate(nAmount),0); if nRemain > 0 and IntAmount > 0 then sWordAmount:= sWordAmount +” Baht And “+ ToWords(round(nRemain,2)*100,0)+” Satang” else if nRemain > 0 and IntAmount…
Read more »Function pwFormatDate not working in Crystal Report
u2lcapw.dll file missing from the “c:\windows\crystal” Download file this link
Read more »Set number date to text date with Crystal report.
local stringvar From_Day; local stringvar To_Day; local stringvar MMM; local stringvar YYYY; From_Day := totext(day(pwformatdate(tonumber(“20211101”))),00); To_Day := totext(day(pwformatdate(tonumber(“20211116”))),00);; MMM := totext(pwformatdate(tonumber(“20211116″)),”MMM”);; YYYY := totext(pwformatdate(tonumber(“20211116″)),”yyyy”);; UCASE(MMM) + ” ” + totext(tonumber(From_Day),”00″) +”-“+ totext(tonumber(To_Day),”00”) + “, ” & YYYY;…
Read more »