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_member11696 · Accepted solution]

Hi Wil,

The correct format would be:

ToText(Year(CurrentDate),0)

0 = no decimal places when converting a number to a string.

Viewer is doing what it should, Report Designer may have a bug.

Don