SQL Date Formats

Just stumbled across this page listing Date formats and the SQL to produce them, all in a handy table.

Very useful when producing SSRS reports..
http://www.sql-server-helper.com/tips/date-formats.aspx

Plugin Registration Tool

Just a quick tip.

if you need to run the plugin registration tool included with the CRM 4.0 SDK using default credientials, leave the Domain Name blank and you'll log straight in.

Useful if you get an unauthorised 401 errors trying to connect.

Adding a Custom Notification to the top of a Microsoft CRM Form

I've decided to update my blog on a more regular basis to give a bit back to those that have helped me so far, as well as an excuse to play around with CRM a little more often!

So to kick things off, here is some javascript I wrote for a customer to add a custom notification to the CRM form, this provides a CRM stylised banner to the top of the form, much like those on products and service activities. Add this javascript to your form onLoad() event and add any conditions as necessary.

Hope it helps!



var warningHtml =
"<table callpadding='0' cellspacing='0'><tr valign='middle'><td><img src=''../_imgs/ico/16_alert.gif'' /></td><td><b>Warning Message</b></td><tr></table>'";

var oDiv = document.createElement("div");
oDiv.id = "new_warning";
oDiv.className = "Notifications";
oDiv.style.padding = "3px";

document.crmForm.all.Notifications.parentNode.appendChild(oDiv);

var theDiv = document.crmForm.all.new_warning;
theDiv.style.display = "";
theDiv.innerHTML = warningHtml;




P.S. This is an unsupported development, usual caveats apply.