I am getting this error when trying to group data on the Status field in Smart Reporting.
I have a union join between work orders and incidents. Does anyone know why this would be happening?
To replicate the issue, add status to your report and attempt to group together some values and click save.
Oops. Looks like a known error:
Remedy - Server - SQL Operation Failed (ARERR 552)due to nvarchar and ntext are incompatible in the equal to operator (SQL Server 402)
Retrieving data ...