Mitch Milam's Dynamics CRM and xRM Discussions

Sharing information with Dynamics CRM users and xRM developers

Combining MSCRM 3.0 data fields in SQL Reporting Services

On March 1, 2006, in Dynamics CRM, Reporting, by Mitch Milam

If you are working with SRS and need to combine two CRM fields together, but having each on its own line, use the following expression:

=Fields!ShipToName.Value & vbCRLF & Fields!ShipToAddress.Value

vbCRLF is a special system constant that contains the values of carriage return and line feed characters.

Thanks for dropping by! Feel free to join the discussion by leaving comments, and stay updated by subscribing to the RSS feed.