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()
c.Init("ENG")
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!