Skip to main content
Language Selector

  1. Other Languages

    (machine translation)

Planview Customer Success Center

Not able to group by Description field

  1. Last updated
  2. Save as PDF

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))