Create Reports using ReportBuilder 2.0 in sql 2008

Article from MSCRM Blog

Installation of Report Builder version April 2009

ASP.NET Startup samples

Site security : http://www.ibuyspy.com/learn/3.5-videos/video-45.aspx

Wiki Resources

A list of 30+ Wiki Solutions is here : http://mashable.com/2008/07/29/wiki-solutions/

FlexWiki is an open source Wiki in .NET www.flwwiki.com Downloaded from her : http://sourceforge.net/projects/flexwiki/

Plugins for FlexWiki are found from this page : http://ods.dyndns.org/FlexWiki/default.aspx/PluginLib/PluginLibraryContents.html

Another list of Wiki solutions in C# is : http://csharp-source.net/open-source/wiki-engines

Good Blogs about CRM

Takin' care of business... with Dynamics CRM 4.0. 

It has a project detailed parts, Lists Must-have tools for CRM, Talks abount Infragistics WebGrid.

Add Link to Record on Outgoing EMail

Embedding Direct Links To CRM In A Workflow Email - Take 2

Email Tracking in CRM

What's New in Microsoft Dynamics CRM 4.0 E-mail Integration

VBScript function List

VBScript functions as W3School

Developing OLAP User Interface articels

Build an OLAP Reporting App in ASP.NET Using SQL Server 2000 Analysis Services and Office XP

Updae Rollup 1 for CRM 4.0

Update Rollup 1 is available for Microsoft Dynamics CRM 4.0

CRM 4 - Feature Deployment Comparison

a simple comparison is here : CRM 4 - Feature Deployment Comparison.

An article from Microsoft is here : Extensibility Feature Deployment Comparison for Microsoft Dynamics CRM 4.0

Javascript function for Yes/No Message box

The message box used here is a VB message box. to use VB in JScript, execScript function is used.

function window.confirm(str)
{
execScript("n = msgbox('" +str+ "','4132', 'Title')", 'vbscript');
return( n == 6);
}

.Net to Javascript Conversion Tool

http://www.stunnware.com/crm2/topic.aspx?id=JSWebService

JScript Scripts for User info and User Roles for Client Side

based on some sources and my alterations:
Bill Owens : http://billoncrmtech.blogspot.com/2008/07/client-side-scripting-retrieving.html
Ronald Lehman : http://ronaldlemmen.blogspot.com/2006/05/finally-there-show-and-hide-fields.html

function getUserRoles( userId)
{
try
{
var command = new RemoteCommand("UserManager", "GetUserRoles");
command.SetParameter("userIds", "" + userId + "");
var oResult = command.Execute();
if (oResult.Success)
{
return oResult.ReturnValue;
}
}
catch(e)
{
alert("Error while retrieving roles.");
}
return null;
}
function userHasRole( userId, roleName, roles)
{
if ( roles == null)
roles = getUserRoles( userId);
if (roles != null)
{
// alert( result);
var oXml = new ActiveXObject("Microsoft.XMLDOM");
oXml.resolveExternals = false;
oXml.async = false;
oXml.loadXML( roles);
roleNode = oXml.selectSingleNode("/roles/role[name='" + roleName + "']");
// alert( "roleNode = " + roleNode );
if (roleNode != null)
{
// if (roleNode.selectSingleNode("roleid[@checked='true']") != null)
if (roleNode.selectSingleNode("roleid") != null)
return true;
}
}
return false;
}

function getUserData()
{
var xml = "" +
"" +
"" +
GenerateAuthenticationHeader() +
" " +
" " +
" " +
" systemuser" +
" " +
" " +
" businessunitid" +
" firstname" +
" fullname" +
" lastname" +
" organizationid" +
" systemuserid" +
" " +
" " +
" false" +
" " +
" And" +
" " +
" " +
" systemuserid" +
" EqualUserId" +
" " +
" " +
" " +
" " +
" " +
" " +
"" +
"";
var xmlHttpRequest = new ActiveXObject("Msxml2.XMLHTTP");
xmlHttpRequest.Open("POST", "/mscrmservices/2007/CrmService.asmx", false);
xmlHttpRequest.setRequestHeader("SOAPAction", "http://schemas.microsoft.com/crm/2007/WebServices/RetrieveMultiple");
xmlHttpRequest.setRequestHeader("Content-Type", "text/xml; charset=utf-8");
xmlHttpRequest.setRequestHeader("Content-Length", xml.length);
xmlHttpRequest.send(xml);
var resultXml = xmlHttpRequest.responseXML;
var entityNode = resultXml.selectSingleNode("//RetrieveMultipleResult/BusinessEntities/BusinessEntity");
var firstNameNode = entityNode.selectSingleNode("q1:firstname");
var lastNameNode = entityNode.selectSingleNode("q1:lastname");
var fullNameNode = entityNode.selectSingleNode("q1:fullname");
var systemUserIdNode = entityNode.selectSingleNode("q1:systemuserid");
var businessUnitIdNode = entityNode.selectSingleNode("q1:businessunitid");
var organizationIdNode = entityNode.selectSingleNode("q1:organizationid");
var result = new Object;
result.firstName = (firstNameNode == null) ? null : firstNameNode.text;
result.lastName = (lastNameNode == null) ? null : lastNameNode.text;
result.fullName = ( fullNameNode == null) ? null : fullNameNode.text;
result.userId = (systemUserIdNode == null) ? null : systemUserIdNode.text;
result.unitId = (businessUnitIdNode == null) ? null : businessUnitIdNode.text;
result.organizationId = (organizationIdNode == null) ? null : organizationIdNode.text;
return result;
}

CRM and SQL Execution

Accessing a SQL Database from a Microsoft Dynamics CRM Plug-in. Shows also how to impersonate users in SQL using "EXECTE AS LOGIN=" command.

CRM sites

Top 14 Microsoft Dynamics CRM Sites and Downloads

CRM and E-mail router on Exchange

Microsoft Dynamics CRM E-mail Router and Exchange 2007: Keeping it Secure

Email router configuration XML file explained

CRM and Reporting services

How it Works: SQL Server Reporting Services and Dynamics CRM
http://blogs.msdn.com/crm/archive/2008/07/18/how-it-works-sql-server-reporting-services-and-dynamics-crm.aspx

CRM Screen casts

Microsoft Dynamics CRM Interviews and Screencasts from July 2008

Microsoft Dynamics CRM Online Video Gallery from July 2008

Blog Posts on CRM Accelerators due in Q3 2008

CRM Accelerators – Part I – Analytics Accelerator

CRM and ISA server

Publishing Microsoft CRM 4.0 through ISA Server 2006 : Blog post on CRMBlog