Formatting Address Data separated by delimiter in the single field | CloudFronts

Formatting Address Data separated by delimiter in the single field


Whenever the a single field in NAV contains Name, Address and other values seperated by delimiter such as ‘,’. But this field cannot formated in SSRS to look appropriate as follows.

For Example in NAV: John Peter, Long Island, New York,US.
Formatting in SSRS:
John Peter,
Long Island,
New York,


Microsoft Dynamics NAV.


  1. Getting a combined value field in this we are concating mutliple values seperated by ‘|’. In this case I’m using the comments on Sales Invoice Lines. This can be a single field or combination of mulitple fields

    Code to combine all comments in single variable
  2. Writing a Query in SSRS report query to seperate the values by delimiter

    Field and its expression:
  3. Output:

    In this output screen the comments are seperated properly in SSRS report.


This is one of the easiest way of combining and seperating and formatting the report by the use of  delimeter.

Share Story :

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.