- You are using MS CRM 2011 and are unable to sort one or more columns in a view
- Error appears when using the web client.
- Server is running Windows Server 2008 family, including SBS2011.
- None of the rollups fix the problem
This problem often occurs intermittently after altering a system view
and can affect both system and custom views. This seems to be a bug where CRM
can alter the disableSorting setting to 1 in the underlying code.
- If the affected view is a system view or one you have custom designed within CRM, remove and re-add the affected columns to the view:
- Edit the affected view, remove the affected columns and publish
- Refresh the browser
- Edit the view again and re-add the columns then publish
- Refresh the browser again
- If the view is part of a custom solution you have designed, edit the XML for the affected view and set the disableSorting property for the affected columns to 0 or try the above.
OTHER POSSIBLE SOLUTIONS:
- If the view contains a column from a related entity, it is not possible to sort on these columns. This is a limitation within CRM
- If the entity view cannot be modified (for instance, the Workflow entity), try an unsupported solution described here: https://mayankp.wordpress.com/2013/07/29/crm-2011-workflow-entity-view-records-are-not-sorted-alphabetically/
- If none of these work, call Microsoft Support, as it could be some hitherto unknown thing that will commit you to an insane asylum if you try to figure it out alone.
