Question Re: Crystal Reports ToText Function in Technology Q&A

Crystal Reports ToText Function

Former Member — Thu, 22 Aug 2013 18:21:14 GMT

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?

Re: Crystal Reports ToText Function

former_member11696 — Thu, 22 Aug 2013 20:18:52 GMT

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

Re: Crystal Reports ToText Function

Former Member — Mon, 11 Jul 2016 10:37:06 GMT

Hi Wil

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

Try

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

Regards
Damien

Re: Crystal Reports ToText Function

aarthir — Sat, 22 Feb 2020 19:56:24 GMT

Hi,

We are using Crystal reports to produce positive pay file and we have a formula

totext(month({@Convert Date}),0)

that extracts month from the date. Formula is working fine for months that are two digits from October through December but for January through September , instead of extracting 01 for month for January, the result only shows 1 .

Is there a better formula that I can use so that the month on the positive pay crystal report to appear as 01,02 for January, February and 10,11,12 for October through December.

Appreciate any input.

Thanks,
Aarthi

Re: Crystal Reports ToText Function

ido_millet — Sat, 22 Feb 2020 22:41:28 GMT

Sure. Use this

ToText(CurrentDate, "MM")

And in a similar way, this is a slightly simpler solution for the original year question:

ToText(CurrentDate, "yyyy")

Re: Crystal Reports ToText Function

aarthir — Sun, 01 Mar 2020 05:50:24 GMT

Thanks so much. It worked!