Wednesday, June 20, 2012

Converting Number to Text in Crystal Reports


When changing numer to text, it puts comma and decimal, for eg
var = 1234

"aa" + CSTR(var)

would give: aa1,234.0
to get rid of , and . use following syntax

TOTEXT({variable}, 0, "")

Arguments: Variable is the one you are trying to convert into text
0: number of decimal places you want
"": thousand separator (here its nothing)


astu...