Numbers to Words CSF

I’m trying to utilize the “Numbers to Words” functionality that appears to be built in to Epicor, but I’m getting hung up on the last step. I created the calculated field in the RDD and everything. Now, in Report Builder, it says to do the following highlighted text, but I’m not sure where/how to do that. Has anyone done this that can offer some guidance?

Try this in SSRS you will need to bring in the reference to EpiNumWords in SSRS

Function GetNumAsString() As String
    Dim c As EpiNum2Words.Convert = New EpiNum2Words.Convert()
    Dim s = c.Amount2String(12.33, "USD", 2)
    Return s
End Function

You will need to add the reference to EpiNum2Words.dll (in your SSRS Install Folder)
E:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\bin

1 Like

Awesome, I can work with this.
Thank you!