Friday, September 16, 2016

Email Templates filtering for MS CRM Users based on Country

Hello Guys,

One of my client was facing an issue in which CRM user were getting trouble choosing a template when replying to customer.

Problem Statement

Let's take an example to understand the problem statement in a better way.

Assume an organization operates globally in Canada / LATAM / US / India.
CRM Users (the CSR's) have to resolve the case's of a customer's and in reply were suppose to use predefined template configured in CRM.

The problem customer representative (CSR's) facing is they are viewing all templates in the system and its becoming difficult for them to choose the correct template.

The number of templates also getting increased as everyone in the system is creating his / her own templates.

Solution Approach

1) We need to implement business unit for each country and allocate user under respective business unit in CRM.

2) We need to modify security role so that user can have an access to business unit level access on email template.

In this way, we would be managing templates country specific and CSR's won't find it cumbersome to choose the correct templates.

Steps to configure Business unit and security role 

1)      Create or modify a Role with Business-Unit level access for an Email Template.


2)      You need to change the user business Unit depending upon which country he / she belongs to. If you open a user records, you will find changing business unit option as shown in below image.

3)      Once a business unit is changed, we need to manage roles for a user’s. 
      Give user a role which is having template access level equal to business unit level. (as in Step 1)

a.       Click on Manage Role on user record.

b.      Select on role created as depicted in below image.


That’s it.

Now when user may be selecting templates or when responding to case as in activity. 
Only email templates which belongs to their business unit will appear.

Vipin Jaiswal

Microsoft Dynamic CRM SQL Server timeout expired

Most of us may have come across SQL timeout expired error while doing some operation in Microsoft Dynamic CRM.


The solution which I am proposing is only applicable to On-Premise and ADFS type of Dynamic CRM installations.

We need to increase the timeout in Registry configuration of windows where dynamic CRM is installed. 

The path to add registry sub key:


There are two DWORD that need to be created.

Value (in Decimal)

Please Note

  • The recommended value of this is between 30 and 300. 
  • The value of 86400 is equivalent to 24 hours.

  • Value, can be larger than 1,000,000.
  • However, do not type a value that is larger than 2,147,483,647. This is hexadecimal 0x7FFFFFFF.

This should only be done temporarily or as a troubleshooting step.
Leaving this setting too high can result in performance issues.

After adding the DWORD it should look something like this.

MSDN provide a detail understanding of SQL time-out.

There are other Timeouts in Microsoft Dynamic CRM.

I hope this will help us avoiding Time out error in SQL.


Thursday, September 15, 2016

How to create a custom Lookup control to be used in web resource in Microsoft Dynamic CRM (MS CRM)?


I was working for one report requirement, which require to filter out records based on Account (Customer).

Let’s assume, if we want to list all opportunities based on account selected.

The first question comes to my mind was, can I use look up control of dynamic CRM as a control directly in my custom report (web-resource) ?

The answer is ‘Yes’, with a little bit of scripting and CSS, we can create our own look up control and invoke Dynamic CRM Look Up Dialog box.

Outcome as in images below

Solution with step by step approach

1)      We need to make reference to JQuery and ClientGlobalContext.js.aspx files in our solution.

<script type="text/javascript" src="ClientGlobalContext.js.aspx"></script>
<script src=""></script> 

2)      The JavaScript method which are used to invoke lookup dialog box of dynamic CRM.

function OpenLookup(objecttypecode)
   var serverurl = "";
   var DialogOptions = new Xrm.DialogOptions();
   DialogOptions.width = 800;
   DialogOptions.height = 600;

   var url = serverurl + "/_controls/lookup/lookupsingle.aspx?class=null&objecttypes=" + objecttypecode + "&browse=0&ShowNewButton=0&ShowPropButton=1&DefaultType=0";

   Xrm.Internal.openDialog(url, DialogOptions, null, null, CallbackFunction);

function CallbackFunction(event)
   var name = event.items[0].name;
   var id = event.items[0].id;
   $('#txt_lookup_name')[0].value = name;
   $('#txt_lookup_id')[0].value = id;

Objecttypecode parameter of method OpenLookup, represent internal value for an entity. 

For an example.
Object Type Code

You can further refer to various entity type and its internal object type code here

3)      A small bit of CSS for making it look like CRM Look Up control.

        .enjoy-css {
            display: block;
            float: left;
            padding:2px 5px;
            border: 1px solid #b7b7b7;
            font: normal 12px/normal segoe ui;
        .lookupImg {
            display: block;
            float: left;
            border: 1px solid #b7b7b7;
        .lookupAlignment {
        span {
            font: normal 16px/normal segoe ui;
        td {
            font: normal 14px/normal segoe ui; width:200px;

4)      HTML Code for rendering control and invoking JavaScript methods.

OpenLookup – method is highlighted in below code and ‘1’ is passed to open lookup control for account entity.

    <br />
        Custom Lookup Control by - Vipin Jaiswal ( <u></u> )

    <br /><br /><br /><br />
            <td>Account </td>
            <td class="lookupAlignment">
                <input type="text" id="txt_lookup_name" class="enjoy-css" />
                <img id="img_lookup_search" src=""
                    class="lookupImg" />

            <td>Selected Account Guid
                <input type="text" id="txt_lookup_id" class="enjoy-css" />
    <br />   

5)      An Image which represent search Icon

Here I am updating this article further, just to inform that we would be getting all values of the Selected view from CRM Dialog box.

We can get other values of the view as well from the dialog box.
In above article, we JavaScript method – function CallbackFunction(event)
In the parameter event, we are getting all the values of selected view.

I put a debugger to check, values.

And here are the values in the JSon format. 

{"name":"primarycontactid","value":"Test Contact"},{"name":"accountprimarycontactidcontactcontactid.emailaddress1","value":""},

I hope you find this article interesting.