To receive our newsletter, please click here.

sign up
Use Social Media to connect with Customer Effective Read Customer Effective's Blog Find Customer Effective on Facebook Find Customer Effective on Linked In Find Customer Effective on Twitter

Delayed IFRAME Loading

Will Wilson
02/05/2010
Suppose you have a CRM form that has several IFRAMES contained in multiple tabs. Loading such a form can sometimes create a performance issue on the client browser due to the frames all loading at the same time. One such...

CRM 4.0 Pre-Filtering Gotcha with Union Queries

Jeff Macfie
02/03/2010
The other day I had to do a report in SSRS and it required me to do a UNION query. In my queries I had a join to the FilteredAccount view so I could use the CRMAF_ prefix to all...

SQL query to retrieve you CRM 4.0 license key

Mark Weilandt
02/02/2010
Retrieving your license key from CRM can be done with a simple SQL query against the MSCRM_Config database. select LicenseKey from ConfigSettings I have seen other posts that suggested querying the _MSCRM database with the query "select licensekey from License"...

Using Microsoft Dynamics CRM internally - "Eating the dog food"

Mike Rogers
02/02/2010
At Customer Effective, we like to use the term “eating the dog food” almost daily to describe our attitude towards running our entire business inside the Microsoft Dynamics CRM application/ platform. We truly have an xRM implementation in place and...

Five Resolutions Every Marketer Must Make in 2010

Mike Rogers
02/02/2010
Guest Blog Post from our Friends at ExactTarget At ExactTarget we are always looking for new ways to help our customers improve their online marketing programs. This year, we thought we’d start the year off as most people do, with...

Preventing Characters from being Entered in a Form Field

Will Wilson
01/07/2010
With CRM, we use a couple of different methods to perform data entry validation before a record is saved to the database: either form javascript, a pre-event plug-in, or some combination of both. For data validation in “real-time” (ie, you...

CRM 4.0 Publish Report for External Use Puts Default Filter In Report

Jeff Macfie
01/05/2010
The other day I was working on a few custom SSRS reports for a client. They need these reports viewable both inside and outside of CRM. Sounds easy enough. After I built the first report I logged in to CRM...

New Testimonial Video from CECRM - "What do you like about Microsoft Dynamics CRM"

Mike Rogers
01/05/2010
This video is a collection of testimonials from our 2009 Customer Effective CRM User Conference. We asked our attendees a simple but important question - "What do you like about Microsoft Dynamics CRM" We love the answers and we hear...

How to query for the Description value for an Entity in CRM

Mark Weilandt
12/23/2009
Due to multilingual support in Microsoft CRM, there is a localized label table used to store the entity description value (and entity label) that you must query. The sql statement to access the description of an entity is below. 1033...

Troubleshooting Error 404 in CRM's Email Router Configuration

Tim Huemmer
12/22/2009
This article explains how to troubleshoot the below error message received when testing Incoming access in CRM's Email Router Configuration Manager: Incoming Status: Failure - The remote Microsoft Exchange e-mail server returned the error "(404) Not Found". This user or...

2010 Microsoft Dynamics CRM / xRM Education Day schedule has been posted

Mike Rogers
12/09/2009
The Customer Effective 2010 CRM / xRM Education Day schedule has been posted. The first two cities - Charlotte, NC and Washington, DC. This allows us to continue the success we had in 2009 with our Education Days in various...