Difference between Cstr and ToText

[Former Member]

I am searching all over internet, what is the difference between Cstr and totext?

If they are same, then which one to use when?

[nikhil_sabnis2 · Accepted solution]

Hi Iti

There is a difference. If you are familliar to Visual Basic family of functions then Cstr() will not be a new function for you.

Since Crystal Reports supports Visual Basic syntax it also supports this function. Whereas ToText() is from Crystal Reports implementation though it is available in both Visual Basic and Crystal syntax.

I don't remember if I had used Totext() as part of Visual Basic anytime.

The functionality of both functions remains same though.

Regards

Nikhil Sabnis

[Former Member · Accepted solution]

Thank you for the details Nikhil,

Actually I got this syntax :

CSTR(totext(abs((number)/anothernumber*100),0))

[abhilash_kumar]

Hi Iti,

There isn't any difference between the two. Usage is completely based on personal choice!

-Abhilash

[Former Member]

Ok, Thanks Abhilash.

I saw few people using Cstr(totext(number)), thats why I am confused.

[abhilash_kumar]

Hi Iti,

The syntax doesn't make sense to me too!

It should just be one of totext(number) or cstr(number).

-Abhilash