Symptoms

In a list view you cannot use the "Group by" functionality on columns if the String type if their maximum lenght is greater that 255 characters. The "Group by" context menu item is greyed out.

Environment

List views and reports

Cause

This a default behavior.

Resolution

There is a workaround for this issue, which involves adding the can_group attribute to the affected column of the table.

1. Navigate to System Definition > Dictionary and access the record name you wish to edit
2. Open the record and click on Advanced View under Related Links.
3. In the Attributes field, add 'can_group=true' as the value of the Attributes field (without quotes) and save.