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.
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.davyknuysen.be/2010/04/16/parent-child-hierarchies-in-reporting-services/
Bye.
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.
Hi,
Say for e.g. we want a report that shows all the contacts based on owners selected.
If we create the query using advanced find, our query will look like this
Here we have selected three users for owner.
From the query we get the initial impression that it won’t be possible to use the above Fetch XML in our report as the Value Tag needs to dynamic based on the no. of the owners selected.
However to use it in the report we need to make the following change in the query
Here @Owners Query Parameter will takes its value from a Multivalued Report Parameter.
Hope it helps.
Hi,
Got to know about this wonderful CRM Wiki page today, so just thought of sharing it.
Thanks George Doubinski and Ben Hosking for publishing it.
Bye.
Hi,
These are the steps we followed to install Microsoft Dynamics CRM 4.0 in Windows Server 2008 R2 machine (Here we had the Microsoft SQL Server 2008 installed on a different server)
Before running the setup, first we added the .NET Framework 3.5.1 Features from Server Manager.
After running the installer we got the following error in the Environment Diagnostics Wizard.
ERROR : (provider: Named Pipes Provider, error: 40 – Could not open a connection to SQL Server) (Microsoft SQL Server, Error: )
We followed the step mentioned in this article to resolve this issue.
On running the installer again, we got this issue
Error : Service msftesql was not found on computer …… The specified service does not exist as an installed service.
We followed the below mentioned steps to resolve the issue
http://social.microsoft.com/Forums/eu/crm/thread/d8dda562-aae6-47b7-9c81-86f98d2b77f6
Bye.
Nishant Rana's Weblog 