window.dataLayer = window.dataLayer || []; function gtag(){dataLayer.push(arguments);} gtag('js', new Date()); gtag('config', 'UA-108815698-1');

Dynamics CRM 2011 Online – VBCRLF Replacement / Text Block

By |2017-12-04T15:00:26+00:00September 7th, 2012|CRM|0 Comments

Recently been involved in re-writing reports for Dynamics CRM 2011 Online and hit an issue where the VBCRLF function would not work with CRM online. Only to further research that code (non-expression) isn’t supported.

In most cases, the following code would work as expected (on an on-premise environment) to have all contact details isolated into one
column.
=”Name: “ + Fields!fullname.Value + VBCRLF +
“Job Title: “ + Fields!jobtitle.Value + VBCRLF +
“Email: “ + telephone1.Value

However, online the code which can be used is Chr(10), this will pretty much (Depending on the length of your columns, edit as required) put every 2nd string-literal onto a new line:

=”Name: “ + Fields!fullname.Value + Chr(10) +
“Job Title: “ + Fields!jobtitle.Value + Chr(10) +
“Email: “ + telephone1.Value

Cheers,

Jason.

Leave A Comment

like what you see? 

Sign-up to our newsletter and never miss out on the latest blogs, events and tech news from the world of risual
SUBSCRIBE!
Give it a try, you can unsubscribe anytime.
I consent to this website use of cookies and third party services. Accept