web
You’re offline. This is a read only version of the page.
close
Skip to main content

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics AX (Archived) / How to get Country fie...
Microsoft Dynamics AX (Archived)

How to get Country field of user from LogisticPostalAddress in SSRS report.

(0) ShareShare
ReportReport
Posted on by yogesh087017

I'm using custom table and I have used LogisticPostalAddress for person details. How can show which user is from which country in ssrs report. Basically I'm new in SSRS so, I'm not sure how join these and display on report

*This post is locked for comments

I have the same question (0)
  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,154 Super User 2026 Season 1 on at

    Hi Yogesh,

    Can you rephrase and elaborate on your question? What fields have been added in your custom table? Is it a reference to the LogisticsPostalAddress or do you have the complete formatted address in your table?

  • yogesh087017 Profile Picture
    yogesh087017 on at

    My custom table has 3 fields id, enrollment date, date of joining. In custom table i have created the relation with recid

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,154 Super User 2026 Season 1 on at

    Hi Yogesh,

    In your initial post you don't provide much information, but you are mentioning something about LogisticsPostalAddress and Country. I asked to explain this and your reply has no details on the address and country anymore. Please provide full details as I'm lost...

  • yogesh087017 Profile Picture
    yogesh087017 on at

    I have one custom table with three field and I have a relation set with logisticpostaladdress table with recid. As location details is stored in logisticpostaladdress table, So how can I fetch the row in ssrs from which country user belong.

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,154 Super User 2026 Season 1 on at

    Hi Yogesh,

    Is the ID field which you mentioned the field which contains the recid of the logisticspostaladdress table?

  • yogesh087017 Profile Picture
    yogesh087017 on at

    yes and the custom table contain recid column which is foreign key that refer to the logisticspostaladdress table

  • André Arnaud de Calavon Profile Picture
    André Arnaud de Cal... 304,154 Super User 2026 Season 1 on at

    OK. I understand now. Have you tried to create a join already? Did you start with a query or data provider for the SSRS report? Did you read the documentation starting here? docs.microsoft.com/.../reporting-in-microsoft-dynamics-ax

  • yogesh087017 Profile Picture
    yogesh087017 on at

    issue got resolved.

  • Suggested answer
    Yash12jain Profile Picture
    Yash12jain 40 on at

    Please use this in your dp class

    DirParty::primaryPostalAddress(CustTable::find(ProjTable.CustAccount).Party).City;

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Introducing the 2026 Season 1 community Super Users

Congratulations to our 2026 Super Stars!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
CP04-islander Profile Picture

CP04-islander 16

#2
GiacomoRovai Profile Picture

GiacomoRovai 4

#3
Douglas Noel Profile Picture

Douglas Noel 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans