ArticlesArticles Most Helpful ArticlesMost Helpful Articles Language SettingsLanguage Settings LoginLogin
RSS Feeds
DrillDown Icon Table of Contents
DrillDown Icon MX
DrillDown Icon Installation of SQLManex(Server install)
DrillDown Icon Multi-Location Sync(OPTIONAL Module)
DrillDown Icon Add Custom Quickview (test)
DrillDown Icon Introduction to MX
DrillDown Icon Setup/Security/Utilities
DrillDown Icon Product Data Management
DrillDown Icon Material Planning
DrillDown Icon Production
DrillDown Icon Report Manager
DrillDown Icon Tool Box
DrillDown Icon MX FAQ's
DrillDown Icon Error 1001. Exception occurred while initializing the installation
DrillDown Icon Error: Unable to create the store directory.
DrillDown Icon Object reference error on Manexcloud
DrillDown Icon Error: Store must be open for this operation
DrillDown Icon Custom Store Procedure/Tables Cannot reside within Manex Database
DrillDown Icon What if I see a Collation error when running reports?
DrillDown Icon Why am I seeing a Authentication Required pop up when accessing MX?
DrillDown Icon ManexCloud Report Permissions
DrillDown Icon Default WebSite/ManEx Http Error 403.14
DrillDown Icon How to Correct the Date Format when Exporting a Report to Excel.
DrillDown Icon Load Report Failed Error When Running a CR over the Web
DrillDown Icon Mapping of Reports to Roles
DrillDown Icon Error Source: Event Log Error
DrillDown Icon Why is Undefined being Displayed in Some Fields on the AP Aging Summary Quick View Report?
DrillDown Icon Why isn't WebManEx Accessible from the Workstations?
DrillDown Icon Why does the system require email address to be populated?
DrillDown Icon Unable to install Manex Services
DrillDown Icon MANUALS and Other Info for SQL MANEX Client Server
DrillDown Icon Customer Relationship Management (CRM)
DrillDown Icon ManEx Minute
DrillDown Icon ManEx Component Exchange
DrillDown Icon ManEx Supplier Directory & Rankings
  Email This ArticlePrint PreviewPrint Current Article and All Sub-Articles
 
What if I see a Collation error when running reports?

Q: What if I see a Collation error when running reports?

A: If you are getting the below error in the image, your server has a different collation than we use by default.  

For clarity, this is caused because we are using a temp table and the server has a different collation method. As long as the server has the same collation, It is fine.


This article explains how to change it:
Article ID: 5916