SSRS- Number to Words

Epicor ERP 10
1

Hi there,
Is anybody ever tried to convert Amount of any report total to words ? I am trying to convert it in words, but stucked with final implementation. I have tried below steps shown in Epicor Help Document:
1.Copied Report data Definition.
2.Added a Caclulated field.
3.Changed its business type to ‘Number to words’ with character data type and assigned a amount field(Integer type).
4.Added this field to SSRS report.

As per Epicor help doc,have to configure .lan file for more customization, but i am trying with defaults.
here is the major problem for me…

2017-09-09_1436
2017-09-09_1436.png956×593 32.4 KB

How i can change “Code format” so the calculations take place for converting in the words ?

Any suggesion / help ?

Thanks :slight_smile:

2

A quick google search shows several solutions for convrting numbers to word in SSRS

2 Likes
3

yes ,but i want to do this task through epicor, if there is a function given.

4

Epicor uses SSRS, use one of the many solutions for doing this in SSRS. There’s nothing within Epicor to do this

5

Yes jose,

Finaly i used the code for this… :smile: