Hi Everyone,

I have a couple customer bringing this issue to us at CRM Support, I would like to use this blog post to share my workaround.

Problem :

When creating / editing an existing report, try certain fields added to the Sort On / Group By column & returns this :

Root Cause :

Javascript called "wsReportDesigner.js" is trying to block the Multi-line text field from added to Group By field.

However arrEntryType [n] from Javascript incorrectly source the ColP_EntryType from SQL database,
thus the field it tries to block is allowed, and field that it is not blocking gets blocked.

Source Code:

In wsReportDesigner.js file, located in C:\Program Files (x86)\Sage\CRM\[CRM INSTALL]\WWWRoot\js\crm\

The line below with in the last else block of function addColumn : function (theList, iDisallowTypeList):

else {

alert(SageCRM.wsReportDesigner.ReportDesignerErrorMessage.OnlyReportColumn);
break;

}

I see JavaScript just warns you that you can't add that field, but eWare.dll prevents it also after I forced the code to enter :

Exception: The field does not exist, or is not a report field, or you are not permitted to use it: : Priority<br>

Tried commented out but it will get rid of the popup but still prevent adding the column to the list.

Workaround from UI :
We need to change the Caption for the problem column, with that it will trick the system to think it is a different EntryType.
Administration > Customization > [Pick the Entity] > Fields > Edit its Caption

Feel free to share if you have any concerns.

Thank you.

Jim Tu

CRM Support North America.