Tag: Microsoft Dynamics CRM

SecurityException: Request for the permission of type “System.Security.Permissions.EnvironmentPermission” failed in CRM 2011 plugin.


We will get this error while using Environment.MachineName
in our plugin code to get the Server Name in case of Sandbox.

Bye.

Security Exception: That assembly does not allow partially trusted callers in CRM 2011 plugin.


Hi,

We were getting the below error in one of our plugins. The reason was because we were making use of HttpContext class of System.Web assembly.

For our on-premise deployment it was working fine, we were getting this issue only on registering plugin on Sandbox mode.

We can find the explanation here

http://social.microsoft.com/Forums/en-US/crmdevelopment/thread/302377cf-97bd-4fe9-b7d0-fa7f08152927/

Bye.

Four Nested If Limitations on workflows in CRM.


Hi,

We recently had a requirement to write a workflow that would require nested if conditions. Much to our surprise we realized that only 4 nested if conditions are supported.

After selecting “Select this row for “IF 5″and clicking on “Add Step”, we can see the Add Step menu greyed out.

The workaround is to use Child Workflow.

Check out this wonderful article

http://www.wipfli.com/BlogPost_MCRM_blog_10_14_09.aspx

Hope it helps.

Hiding Ribbon Button using JavaScript in CRM 2011.


Suppose based on some value we want to hide the Run Workflow button from Ribbon through JavaScript in form’s onload event.

Firt get the Id of the button using IE Developer Tool and then use display property to hide it


var btnRunWorklfow=top.document.getElementById("new_student|NoRelationship|Form|Mscrm.Form.new_student.RunWorkflow-Large");
btnRunWorklfow.style.display='none';

Bye.

Hierarchical report in SSRS to show users and their managers (CRM)


Hi,

Just created a simple SSRS report that shows the Hierarchy of the users and their manager.

This is how the report looks like

The DataSet query used

Select the row, right click and select group properties option

Select Grouping based on systemuserid

Toggle the visibility based on FullName

Select parentsystemuserid as Recursive Parent from the Advanced option

Set the Left Padding property for the fullname TextBox.

Set the expression for level as Level()

The posts from which I learned creating the hierarchical reports

http://blog.infotoad.com/post/2009/08/10/Working-with-a-Recursive-Hierarchy-Group-in-SQL-Reporting-Services-2008.aspx

http://blog.davyknuysen.be/2010/04/16/parent-child-hierarchies-in-reporting-services/

Bye.

Sorting on Link Entity’s Attribute in Fetch XML (CRM 2011)


Hi,

We had a requirement where we wanted our resultset to be sorted based on the associated link entity’s attribute.

This is how we need to write our fetch xml query.

Suppose we want to get all the Accounts records and its owner information sorted based on Owner’s Job Title. (Descending)

For this our Fetch XML query be something like this

The result

Bye.

Advertisements