Safe Cast in Crystal Reports Comparison

1 vote

1 answer

152 views

sql-server sql-server-2012 crystal-reports

                          Using Crystal Reports version 14.0.3.613RTM

With SQL Server 2012 onward, if a field has both number and string data, I can use try_convert to compare, i.e.

    TRY_CONVERT(int, resource_code) > 999999999

How do I handle this in Crystal Reports?

I tried:

    ToNumber({sch_resource.resource_code})

But if resource_code isn't a number, CR barfs.

Asked by epardee (21 rep)

Feb 21, 2018, 08:39 PM
Last activity: Feb 24, 2018, 11:45 AM

Safe Cast in Crystal Reports Comparison

Related Questions