okt 22 Microsoft CRM SQL Reports T-SQL Table of contents TOC

Create Table of contents (TOC) in SQL Reports

Hi all, This night I finished a advanced report with with table of contents with page numbers of cause it’s all dynamics and data is feeded from a Microsoft CRM database but that could be any data source if needed. The scenario is that my customer needed to print product brochere diretly from inside of…

Read more

okt 17 c# Microsoft CRM WFA Workflows

Find day af week from date

Hi, I was playing around with a workflow where needed to have different functions depending what day of week it was. So I manage to find some old code there actual worked. I compiled the WFA and registered it into CRM and the magic happend I was feeding it with the run date of the workflow,…

Read more

okt 15 integration Microsoft CRM SAP Scribe

Experiences Sharing: Integration between SAP (Unix) and Microsoft CRM

Hi All, This week I was in Germany at a customer there needed to make a 2 way integration between SAP (Unix) and Microsoft CRM. Together with the SAP XI people from the customer we together managed to get it working with a message flow from SAP XI into the message queue in windows where my…

Read more

sep 11 Microsoft CRM SQL Reports T-SQL

Check if file excist in SQL report

Hi, I needed a script to check if a picture file excist for use in my data set. This is the normal SQL script: But that will not work from inside the report manager, but if you build it into a function on the sql server it will work. Normally when I build my own…

Read more

aug 13 Java Javascript Microsoft CRM scripts

Lookup values from parent entities

Hi, This is another way to lookup values from parent entities this will work on all versions of CRM (OnPremise, Hosted, Online) Have fun! /Anders //debugger;var AccountLookUp = crmForm.all.parentcustomerid.DataValue;if (AccountLookUp != null && AccountLookUp != “undefined”) { var AccountID = AccountLookUp[0].id; var Accountxml = “” +”<?xml version=”1.0″ encoding=”utf-8″?>” +”<soap:Envelope xmlns:soap=”http://schemas.xmlsoap.org/soap/envelope/” xmlns:xsi=”http://www.w3.org/2001/XMLSchema-instance” xmlns:xsd=”http://www.w3.org/2001/XMLSchema”>” +GenerateAuthenticationHeader() +” <soap:Body>”…

Read more

aug 11 add-in excel Microsoft CRM office

Excel Add-In for easier import of Excel data in Microsoft Dynamics CRM

Hi all, I have been using this tool from proMX for a long time now and need to share it with you guys. http://promx.wordpress.com/2008/06/16/excel-add-in-for-easier-import-of-excel-data/ It’s the right way to export data from excel to csv files without that excel fucks it up Regards, Anders

Read more

aug 11 Java Javascript Microsoft CRM

Setting defaul values in CRM

Hi all, Here is a nice little collection of examples on how to set default values with javascript: http://msdn.microsoft.com/en-us/library/cc468412.aspx var CRM_FORM_TYPE_CREATE = “1”; if (crmForm.FormType==CRM_FORM_TYPE_CREATE) { // Set the value of the topic field. var topic = crmForm.all.name; topic.DataValue = “New Opportunity: “; // Price List – a lookup field. var priceList = crmForm.all.pricelevelid; //…

Read more

aug 11 Java Javascript Microsoft CRM

Java script to lookup service on related case on service activity

I have made this script where I lookup the service id and name on the related Case on the Service Activity and then stamp it into the created Service Activity Service field. I have been using the JavaScript libary from Daniel Cai’s blog: http://danielcai.blogspot.com/2010/05/mscrm4-web-service-toolkit-for.html Below you will see my script it should be easy to…

Read more

aug 11 Java Javascript Microsoft CRM

Easy way to use JavaScript

Hi All, I found this blog from Daniel Cai who have made a javascript libary where you can lookup values from related entities, create record etc. all made in a easy way. only thing is that you will need to have directly access to the server so hosted crm and crm online users can’t use…

Read more

jul 26 Microsoft Microsoft CRM scripts T-SQL tables update

T-SQL Make SLECT statement only on fields with data in

If you need to make a data dump of a table but don’t want to have all the empty fields, they just run this script and it will create the needed select statement that you can copy paste into a new query. DECLARE @TAB_NAME NVARCHAR(MAX) SET @TAB_NAME = ‘SystemUser’ DECLARE @RET_QUERY NVARCHAR(MAX) SET @RET_QUERY =…

Read more