Tuesday, February 25, 2014

Total record count in MS CRM grid

By default CRM is not giving total number of records for entity in grid. If there are more than 5000 records, then CRM will display 5000+ records and when you navigate through 5000+ then count is changing per page size.
If want to show count of total number of records in grid, then need to modify database values.
1.       Open MSCRM_CONFIG database in SQL server management studio

select * from DeploymentProperties where ColumnName ='TotalRecordCountLimit'

2.       In this table IntColumn default value is 5000.
3.       Update IntColumn value to -1

Update DeploymentProperties Set IntColumn=-1 Where ColumnName = 'TotalRecordCountLimit'

4.       When using -1, then CRM will take count of all records.
5.       If don’t want all records, but want say 15000 records count then update IntColumn value to number of record count want.
6.       Reset IIS.

7.       Try now.. 



Monday, February 24, 2014

CRM 2013 Form change Footer Color for all forms

Footer before changing color

Footer After Changing Color

This is unsupported way of MS CRM 2013 customization.

1.       Goto C:\Program Files\Microsoft Dynamics CRM\CRMWeb\_forms\styles
2.       Make a copy of read.css.aspx file
3.       Open read.css.aspx
4.       Find TABLE.ms-crm-Form-StandaloneSection section in CSS file.
5.       Add
in TABLE.ms-crm-Form-StandaloneSection

table-layout: fixed;
width: 100%;
line-height: 16px;

Replace with

table-layout: fixed;
width: 100%;
line-height: 16px;

6.       Save file.
7.       Clear browser cache

8.       Try now.

MS CRM 2013 Quick find with always wildcard charcter

This is unsupported way of CRM customization. when any new rollup installed these changes may be removed.

1.       Go to C:\Program Files\Microsoft Dynamics CRM\CRMWeb\_static\_common\scripts
2.       Find stage.js script file.
3.       Make a copy of this file.
4.       Open Stage.js script file.
5.       Find function function quickFind(oGrid)
In this function find

sFindCriteria = Trim(findCriteria.value.replace(/[\*]+/, "*"));findCriteria.value = sFindCriteria;

6.       Replace

sFindCriteria = Trim(findCriteria.value.replace(/[\*]+/, "*")); 

If wants wild chard character always comes first when entered any key word for search (*abc)

sFindCriteria=Trim(findCriteria.value.replace(/[*]+/,""));if (sFindCriteria != "" && sFindCriteria.substr(0, 1) != "") sFindCriteria = "*" + sFindCriteria;

If wants wild chard character always at end (abc*) then

sFindCriteria=Trim(findCriteria.value.replace(/[*]+/,""));if (sFindCriteria != "" && sFindCriteria.substr(0, 1) != "") sFindCriteria =  sFindCriteria+"*";

if wants wildchard character in both places (*abc*)

sFindCriteria=Trim(findCriteria.value.replace(/[*]+/,""));if (sFindCriteria != "" && sFindCriteria.substr(0, 1) != "") sFindCriteria =  "*"+sFindCriteria+"*";

7.       Save the file.
8.       Clear your browser cache
9.       Try now..