Knowledge found and lost while working with Microsoft Dynamics CRM
RSS icon Home icon
  • Combining MSCRM 3.0 data fields in SQL Reporting Services

    Posted on March 1st, 2006 mitch Print Print 2 comments

    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.

    Dynamics CRM, Reporting
    1 Star2 Stars3 Stars4 Stars5 Stars (No Ratings Yet)
    Loading ... Loading ...
    1,769 views
     

    2 responses to “Combining MSCRM 3.0 data fields in SQL Reporting Services”

    1. Sweet. Nice tip Mitch!
      Thanks,
      Matt Wittemann

    2. Thanks Matt.

    Leave a reply