SQL Server: "All Values" option in Queried parameter

To add the option "All" in a Queried SQL parameter change your (list) dataset like this:

The dataset where you use the parameter should look something like this:

SELECT statecodename, statecode

FROM FilteredOpportunity AS CRMAF_FilteredOpportunity
WHERE (accountid = @CRM_Accountid) AND (statecode = @CRM_Opp_Statt) OR
(accountid = @CRM_Accountid) AND (@CRM_Opp_Statt = - 1)

For Text variables:
Use a (list) dataset, similar to this:

The dataset where you use the parameter should look something like this:

SQL Server: "All Values" option in Non-queried parameter

To add the option "All" in a Non-queried SQL parameter change your dataset like this:

SELECT statecodename, statecode
FROM FilteredOpportunity AS CRMAF_FilteredOpportunity
WHERE (accountid = @CRM_Accountid) AND (statecode = @CRM_Opp_Statt) OR
(accountid = @CRM_Accountid) AND (@CRM_Opp_Statt = - 1)

Next step is to add the option "All" to your Non-queried parameter:

 
 
 
 
 
 
 
 
 
 
 
 
 


Works like a charm!
 
Original post: http://timothychenallen.blogspot.com/2007/06/sql-server-all-values-parameters-in.html

Nice post about upgrading excisting CRM 4.0 32-bits deployment to CRM 2011

http://weblogs.asp.net/pabloperalta/archive/2010/11/01/step-by-step-installing-crm-2011-on-premise-and-migrating-from-dynamics-crm-4-0-32-bits-on-premise.aspx

Thanks Pablo!

Importing two or more entities from a Single File (2011)

Interessant artikel dat uitlegt hoe je Accounts en Contacts vanuit 1 bestand in één keer kunt importeren in CRM 2011.

http://blogs.msdn.com/b/crm/archive/2010/11/04/importing-two-or-more-entities-from-a-single-file.aspx

Uitvragen aantal veld (2011)

function noe()
{
var locAttr = Xrm.Page.data.entity.attributes.get("numberofemployees");
alert(locAttr.getValue());
}

Eigenschappen van een Lookup uitvragen (2011)

function Test()
{
var LookupItem = Xrm.Page.data.entity.attributes.get("primarycontactid");
if (LookupItem.getValue() != null)
{
// The GUID of the lookup
alert(LookupItem.getValue()[0].id);

// The text value of the lookup
alert(LookupItem.getValue()[0].name);

// The entity type name
alert(LookupItem.getValue()[0].typename;

// The entity type code of the lookup 1=account, 2=contact
alert(LookupItem.getValue()[0].type);
}
}

2011 – Hide Areas of a Form

These code snippets will hide specific areas of the Form.

// Hide the Ribbon Toolbar and move the form Content area to the top of the window.
window.top.document.getElementById(“crmTopBar”).style.display = “none”;
window.top.document.getElementById(“crmContentPanel”).style.top = “0px”; // Move Form Content area up to top of window, initial style.top is 135px

// Hide Left Hand Nav bar / pane
document.getElementById(“crmNavBar”).parentElement.style.display = “none”;
document.getElementById(“tdAreas”).parentElement.parentElement.parentElement.parentElement.colSpan = 2;

// Hide the Breadcrumb and Record Set Toolbar
document.getElementById(“recordSetToolBar”).parentElement.style.display = “none”;

// Hide the Form Footer Bar
document.getElementById(“crmFormFooter”).parentElement.style.display = “none”;

Original Post by Rhett Clinton