If a user receives a collation error when running reports, this simply means that the user's server has a different collation than the one manex uses by default.
This is caused because manex uses a temp table, and the server has a different collation method. As long as the server uses the same collation, there will be no issues.
This article explains how to solve the issue: https://www.mssqltips.com/