Skip to main content
Planview Customer Success Center

Not able to group by Description field

Symptoms:
An error occurs when trying to group a report based on the Time description field.

Error/warning messages:
The text, ntext, image data types cannot be compared or sorted

Reason:
Fields of Text data type cannot be used in grouping. This is an SQL server limitation.



Resolution:
Create a custom field in the report and cast the description field into another type that can be used in grouping, e.g.

cast ( [Standard Task.Description] as nvarchar(200))