Crystal Reports ToText Function

[Former Member]

Hello

I have a report that takes the current year and converts it to text using the ToText function e.g. ToText(Year(CurrentDate))

In Crystal this returns 2013

When I run the same report using the .NET runtimes for Crystal 2011, the same formula return 2,013.00

I know that the ToText function has extra parameters to handle formatting, however, I expect the results to be consistent between Crystal Reports and runtimes. Is there an over-ride for the runtimes (registry setting perhaps) that can be used to make the results formatted like Crystal Reports?

[Former Member]

Hi Wil

ToText(Year(CurrentDate),0) will give you "2,013".

Try

ToText(Year(CurrentDate),0,"") this will give you "2013"

Regards
Damien