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?
1 Like
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
2 Likes
Awesome, I can work with this.
Thank you!
1 Like
Hi guys, help me!!!
That .dll is found
E:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin
But I still get the same error. I’m working on Epicor 2024.2.12
1 Like