Monthly Archives - October 2012

How To Get Total Record Count in CRM Dynamics 2011

When you write an advanced find query in Microsoft CRM Dynamics you would like to know total number of records count. The view shows you only maximum of 250 records at a time. In MS CRM 2011 on bottom of page view, it displays 5000+ count sign if records are greater than 5000 but you cannot find exact count. There are two approaches you can get exact count of records. Export to Excel: Write your view in CRM Dynamics then from view, click Export Data to Excel. After exporting data in CRM Dynamics you can scroll right bottom of the excel file to get total number of records or use the Excel function ROWS(array). Note: There is a 10000 records export download default limit, If you would like to increase this limit please check my article “How to Increase the Maximum Records exported to Excel from CRM DynamicsReport Wizard : The second method to display total records count in CRM dynamics is  built in reports wizard. You can make available this report in CRM entity’s view or form record. I think this approach is more easy and recommended. If you like this post please click LIKE and visit my sponsors thanks !!!

How to Increase the Maximum Records exported to Excel from CRM Dynamics

In this post I am going to explain how we can increase maximum number of records that can be exported from CRM Dynamics 2011 to Excel spread sheet. By default maximum number of records can be exported are 10000 using the “Static worksheet with records from all pages in the current view” feature. Even if you export more than 10,000 records, only first 10,000 records would be visible. It is quite hard to find exact number of records in this way. To increase this default parameter value you need to update MaxRecordsForExportToExcelcolumn in OrganizationBase. This can only be done in SQL Server management studio. Please follow these steps:
  1. Open SQL      Mangement Studio
  2. Use the      <your organization>_MSCRM database
  3. Open the      OrganizationBase table
  4. Locate the      column  MaxRecordsForExportToExcel
  5. Run Update      Query to change the value to the new value
 1. Select MaxRecordsForExportToExcel From OrganizationBase 2. Update OrganizationBase Set MaxRecordsForExportToExcel=50000 In my case there is only one record in OrganizationBase table that’s why I didn’t write where condition. If you are having more than one organization records in this table, you should have to apply where condition to specify which oranization’s MaxRecordsForExportToExcel value you are changing, otherwise it will change for all organization’s MaxRecordsForExportToExcel value to 50,000. If you like this post please click LIKE and visit my sponsors thanks !!!

How to Pass 77-891: Microsoft Office 365

I recently passed my exam 77-891 MOS Microsoft 365 office Specialist and i am sharing learning material for people who wanted to pass this exam. This exam is divided into four major modules 1. Navigate Office 365 1.1. Navigate Office 365 Features 1.2. Navigate in Applications 2. Communicate by using Office 365 Outlook Web Application 2.1. Manage E-mail 2.2. Organize Calendars 2.3. Manage Contacts 2.4. Manage Tasks 2.5. Configure Outlook Web Application Options (more…)

How to Install CRM Dynamics 2011 Outlook Client

In this post i am going to explain, how you can install CRM Dynamics 2011 Outlook Client.


The following prerequisites are required before you can install and use the full functionality of Microsoft Dynamics CRM:
  • Internet Explorer 8 or 9 (although IE8 will work, IE9 is highly recommended)
  • Microsoft Outlook 2010
  • Client operating system: Windows 7, Windows XP, Vista
  • CRM account access
  • You must be an Administrator on your PC to install new software.

Installation Process


Ensure Microsoft Outlook is closed prior to the installation.

Client Software

Download the following client software file and save it in your Downloads folder: Information about this download can be found here:

Update Software

Download the following update file (‘rollup 10’ - version 05.00.9690.2730, published: 16/08/2012) and save it in your Downloads folder: Information about this update can be found here:

Install the client

    1. Run the following file that you downloaded in your Downloads folder: CRM2011-Client-ENU-i386.exe
    2. This will prompt you for a location to extract the files:
    3. Ensuring ‘Desktop’ is selected first, click on the ‘Make New Folder’ button.
    4. Create a folder for example CRM:
    5. Select it and click on ‘OK’.  The files will extract which may take several minutes:
    6. The installation will automatically start the ‘Microsoft Dynamics CRM 2011 for Outlook Setup’ wizard.  Follow the steps in the wizard, accepting all default options.  The process may take several minutes:
CRM Client for Outlook
CRM Client for Outlook
Do not restart Microsoft Outlook at this point.  Proceed to install the update instead

Install the Update

  1. Run the following file that you downloaded in your Downloads folder: RM2011-Client-KB2710577-ENU-i386.exe
This will start the Update Rollup wizard:
Rollup 10 CRM Dynamics
Rollup 10 CRM Dynamics
2. Follow the wizard through until the end:
Update Completed CRM Rollup
Update Completed CRM Rollup

Configuring Microsoft Dynamics CRM for First Use

After Microsoft Dynamics CRM has been installed on a PC, the first time every user of that PC runs Outlook, the configuration wizard will automatically start.  This will only once, per user, per PC:
  1. Launch Microsoft Outlook.
  2. The configuration wizard should automatically start:
Dynamics CRM for Outlook
Dynamics CRM for Outlook
  If the configuration wizard does not start automatically, you must run it manually by clicking on the ‘Configure Microsoft Dynamics CRM for Outlook’ button on the new ‘CRM’ tab on the Microsoft Outlook ribbon:
CRM Client Configuration
CRM Client Configuration
  3. Enter ‘Your Server Address‘ into the ‘Server URL’ field and click on ‘Test Connection’.  The correct ‘Organization Information’ should automatically populate: 4. Select ‘OK’ and the organisation will be added and initialised:     Microsoft Dynamics CRM can only allow one PC to synchronise with Microsoft Outlook at any one time.  If you have previously installed or used Microsoft Dynamics CRM on another PC, that PC will automatically be set as the synchronisation client. When you use Microsoft Dynamics CRM on a different PC, if it detects that you have already have a synchronisation client, it will prompt you as follows:
CRM Dynamics Sync Message
CRM Dynamics Sync Message
  You should always answer ‘Yes’ to this question if you want your work in Microsoft Dynamics CRM to be synchronised immediately with Microsoft Outlook.  If you select ‘No’, the work you have carried out in Microsoft Dynamics CRM will not be synchronised until you next run Microsoft Outlook on your other PC. If you answer ‘Yes’ to this message, when you return to your other PC, the same prompt will appear and again you should answer ‘Yes’.

If hope you liked this post, please share and visit few of my sponsors thanks