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.

 

2 Responses to Combining MSCRM 3.0 data fields in SQL Reporting Services

  1. MattNC says:

    Sweet. Nice tip Mitch!
    Thanks,
    Matt Wittemann

  2. mitch says:

    Thanks Matt.

Leave a Reply

Your email address will not be published. Required fields are marked *

*

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>