What's the use of CLSEpicor.dll

What the use of CLSEpicor.dll

I think you’ll have to provide a lot more context to motivate anyone to answer that

after upgrade SQL Server 2016 to 2017 reports not working due to below errors
Failed to load expression host assembly. Details: Could not load file or assembly ‘CLSEpicor, Version=1.0.0.0, Culture=neutral, PublicKeyToken=null’ or one of its dependencies. The system cannot find the file specified.

Searching the forum for “CLSEpicor.dll” turns up several posts, including this one:

that post is about VS editor. For SSRS it should be in Report Server folder, in my case it is in “C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin”

So Epicor has a couple of custom DLL’s that they use to turn numbers into words (for checks among other things)

These DLL’s are installed in your
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin

When you first deploy epicor and this DLL is one of those.

Do you think that redploying the Report Service in the Admin Console would take care of this?

Yes re-deploying should, I would check the Import Reports when you do just make sure you have good SSRS backups and make sure the account you are deploying with has full rights to
C:\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin

or if using a separate SQL DB

\\remote\Program Files\Microsoft SQL Server Reporting Services\SSRS\ReportServer\bin

Thanks, Issue resolved :slight_smile:

There are two files CLSEPicor.dll and EpiNum2Words.dll

If you are trying to install the app server with a scale out deployment, or even just HA, then these files need to be on each SSRS install.