Is there a supported way to convert a number into its written-out word form (for example, 100 into 'One hundred') on a Report Designer layout, without relying on a custom SQL workaround that breaks on certain negative or large numbers (like an ORA-01854 Julian-date error)?

All FAQ questions / Reporting and analytics

Answer

Yes — number-to-words conversion is a standard built-in function of the Report Designer layout tool itself, so there's no need to configure a custom field or write SQL to achieve it; using the built-in function avoids the edge-case errors (like the Julian-date range error) that a homegrown SQL-based conversion trick can run into for large or negative values.

Documentation-based answer. Confirm the product and release before applying it. This answer has not been verified in an IFS environment.

← Browse Reporting and analytics questions