web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Make LogisticsPostalAd...

Microsoft Dynamics AX (Archived)

Make LogisticsPostalAddress' Address in 1 Line

(0) Share

Report

Report

Posted on by XSpy

209

im making a report where im getting Address Field from LogisticsPostalAddress Table

i put it in a textbox, it is working properly, but the output is making many lines, it looks like this:

----

street

city

country

----

i want it to be in a 1 line only, and look like this:

----

street city country

----

is there a textformatting to make it look like that?

im using Visual Studio 2013 and AX 2012

please help, thanks

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (6)

Answers Img

Answers (3)

Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

Simply replace new line characters with spaces (or whatever delimiter you want).

Was this reply helpful? Yes No
XSpy 209 on at

Like (0)

Report

it 1 field(Address), and i can't replace it in table, i just need to view it in 1 line.

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,965 Most Valuable Professional on at

Like (0)

Report

I know it's one field - I told you how to manipulate the string in the field before displaying it.

You can do it in an SSRS expression (Replace() function), in your RDP class, write a display method...

Was this reply helpful? Yes No
Hariharans87 3 on at

Like (0)

Report

You can concatenate the fields and use in SSRS report. LogisticsPostalAddress.Street + ',' + LogisticsPostalAddress.City + ',' + LogisticsPostalAddress.County

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 49,438 User Group Leader on at

Like (1)

Report

I do agree what martin is suggesting.

inside ax you can write some code as udnder

TextBuffer txt = new TextBuffer();

;

txt.setText(Table.AddressFieldHavingAdress); //assign text to textBuffer

txt.replace('\n',' '); //replace new line

Table.AddressFieldHavingAdress = txt.getText(); //get back text, after replacement of new line with space

Was this reply helpful? Yes No
XSpy 209 on at

Like (0)

Report

thank you all, finally got it with Martin and Sohaib's suggestion.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans