Let’s say you need to fetch the GUID of an entity record in a process in order to build a link in an e-mail. The default process wizard does’nt give you this information. So you need to build your own custom workflow activitylibrary in Visual Studio.
Here’s the basic how to: http://msdn.microsoft.com/en-us/library/gg328515.aspx
And here’s the code for extracting the ID:
This is a follow up on previous post Show a link to document properties in Sharepoint 2010 search result. Here’s the full XSL copied from the Core Search Results web part:
Find the table ConfigSettings in the MSCRM_Config database. Set the HelpServerURL value to blank (or your CRM domainname). Then recycle the CRM application pool in IIS to update the changes. Done!
select * from ConfigSettings
update ConfigSettings set HelpServerUrl = null
Say you have seconds stored in the database, but you want to show them as hours and minuts. Here’s a simple SQL Server Reporting Services expression you can use:
=Int(Sum(Fields!DurationSec.Value) / 60) & “:” & Right(“0” & (Sum(Fields!DurationSec.Value) – (Int(Sum(Fields!DurationSec.Value) / 60) * 60)), 2)