Create a button on a MS CRM 4.0 form

First of all we need to create a nvarchar attribute and put it on the form where we want our button.

Now Copy the following code in the form OnLoad event.

 
/* Jscript */

   
function gConvertTextFieldToButton(fieldname, buttontext, buttonwidth,clickevent, title){

 /*
 Description: Converts a text attribute to a Button
    For every Button you need, create a nText Attribute and place it on the Form
    Original code by: mario raunig, world-direct 04/2008
 Params:   fieldname  - name of the TEXT field
    buttontext  - text will be placed on the button
    buttonWidth - size of button
    clickevent  - function object; pass the function as an object - without th ()  
 Example :  gConvertTextFieldToButton('new_emailbutton', 'Send mail to GTPM','200px',sendEmail);   
 Author:  GP
 */
 
 //check if object exists; else return
 if (document.getElementById(fieldname) == null){
  return;
 }
 
 functiontocall=clickevent;
 crmForm.all[fieldname].DataValue = buttontext;
 crmForm.all[fieldname].readOnly = true;
 crmForm.all[fieldname].style.borderRight="#3366cc 1px solid";
 crmForm.all[fieldname].style.paddingRight="5px";
 crmForm.all[fieldname].style.borderTop="#3366cc 1px solid";
 crmForm.all[fieldname].style.paddingLeft="5px";
 crmForm.all[fieldname].style.fontSize="11px";
 crmForm.all[fieldname].style.backgroundImage="url(/_imgs/btn_rest.gif)";
 crmForm.all[fieldname].style.borderLeft="#3366cc 1px solid";
 crmForm.all[fieldname].style.width=buttonwidth;
 crmForm.all[fieldname].style.cursor="hand";
 crmForm.all[fieldname].style.lineHeight="18px";
 crmForm.all[fieldname].style.borderBottom="#3366cc 1px solid";
 crmForm.all[fieldname].style.backgroundRepeat="repeat-x";
 crmForm.all[fieldname].style.fontFamily="Tahoma";
 crmForm.all[fieldname].style.height="20px";
 crmForm.all[fieldname].style.backgroundColor="#cee7ff";
 crmForm.all[fieldname].style.textAlign="center";
 crmForm.all[fieldname].style.overflow="hidden";
 crmForm.all[fieldname].attachEvent("onmousedown",push_button);
 crmForm.all[fieldname].attachEvent("onmouseup",release_button);
 crmForm.all[fieldname].attachEvent("onclick",functiontocall);
 crmForm.all[fieldname].style.lineHeight="14px";
 crmForm.all[fieldname+'_c'].style.visibility = 'hidden';
 crmForm.all[fieldname].title=title;
 window.focus();
 
 //*********************************************************
 function push_button(){
  window.event.srcElement.style.borderWidth="2px";
  window.event.srcElement.style.borderStyle="groove ridge ridge groove";
  window.event.srcElement.style.borderColor="#3366cc #4080f0 #4080f0 #3366cc";
 }

 //*********************************************************
 function release_button(){
  window.event.srcElement.style.border="1px solid #3366cc";
 }
}
    

Maximum of 5000 responses from a FetchXml

Edit the registry

Click Start, click Run, type regedit in the Open box, and then click OK.

Locate and then select the following registry subkey:

HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM

On the Edit menu, point to New, and then click DWORD Value.

Type TurnOffFetchThrottling, and then press ENTER.

Right-click TurnOffFetchThrottling, and then click Modify.

Type a number other than 0 in the Value data box, and then click OK.Note Step 6 lets you retrieve the number of records specified in the Count attribute of your fetch statement.

On the File menu, click Exit.

Extend 5000 limit on data retrieval

With CRM 4.0 and Microsoft CRM 2011 there is a default limit for the number items that can be retrieved when making various types of web service calls into the CRM.

Typically this limit is set to 5000 but with some types of calls it will return 7000. In any case, the process to remove the limit and set it to 20,000 is very easy.

On the server running CRM

1. Click Start, click Run, type regedit in the Open box, and then click OK.
2. Locate and then select the following registry subkey:

   HKEY_LOCAL_MACHINE\Software\Microsoft\MSCRM

3. On the Edit menu, point to New, and then click DWORD Value.
   
4. Type TurnOffFetchThrottling, and then press ENTER.
   
5. Right-click TurnOffFetchThrottling, and then click Modify.
   
6. Type a number other than 0 in the Value data box, and then click OK.
   

   
   Note Step 6 lets you retrieve the number of records specified in the Count attribute of your fetch statement.

7. On the File menu, click Exit.