Skip to main content

Notifications

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

in X++ SSRS Report address format.

(0) ShareShare
ReportReport
Posted on by 130

Hi guys,

i want to in the SSRS report Address format 

Example ;

RBI|Colony|2 street|UAE|

mob|Fax 000232|Email |

how to achieve in X++ Code what to be done?

Thanks.

  • WaytoAx Profile Picture
    130 on at
    RE: in X++ SSRS Report address format.

    many thanks Christoph

  • Verified answer
    Christoph Thaler Profile Picture
    5,442 on at
    RE: in X++ SSRS Report address format.

    Hi, 

    you can find the menu here:

    pastedimage1585815633912v1.png

  • WaytoAx Profile Picture
    130 on at
    RE: in X++ SSRS Report address format.

    Hi Christoph where is Find the above the Address setup which module.

  • WillWU Profile Picture
    22,352 on at
    RE: in X++ SSRS Report address format.

    Hi WaytoAX,

    You can select “Add Page Header” and “Add Page Footer” options in report menu.

    Refer to the link:

    community.dynamics.com/.../ax-2012-creating-the-ssrs-report-precision-design

    You need to write a simple expression on the textbox control which is placed on the footer and you can utilize expression to show different footer on different pages.

  • Verified answer
    Christoph Thaler Profile Picture
    5,442 on at
    RE: in X++ SSRS Report address format.

    Hi,

    it seems to be the footer of the document, isn`t it? So I assume this is the master data of the legal entity correct? Usually these fields are in the report header datasource. Here an example of the freetext invoice

    pastedimage1585806502820v1.png

    with this fields available you can place them on your report as needed.

  • Verified answer
    Sergei Minozhenko Profile Picture
    23,091 on at
    RE: in X++ SSRS Report address format.

    Hi WaytoAx

    Check LogisticsPostalAddressStringBuilder class. You can try to create a new format on the form mentioned by Christoph and pass a new formatId as parameter to LogisticsPostalAddressStringBuilder class and build address.

    The result can be saved to separate field in table DP and added to the report.

  • WaytoAx Profile Picture
    130 on at
    RE: in X++ SSRS Report address format.

    Thanks for your replay Christoph Thaler.

    i want to in the SSRS Design Address format

    IMG_2D00_20200401_2D00_WA0058.jpg

  • Suggested answer
    Christoph Thaler Profile Picture
    5,442 on at
    RE: in X++ SSRS Report address format.

    Hi WaytoAx,

    usually there is no need to do the address layout in the SSRS report. In D365 you can define the layout in the global address book setup on your own. At the end you will get the data in this format into the SSRS report (sales order confirmation, purchase order, packing slip,...) 

    If you created an own SSRS report you can reused the logic from these reports in your dataprovider.

    pastedimage1585803811122v1.png

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

🌸 Community Spring Festival 2025 Challenge 🌸

WIN Power Platform Community Conference 2025 tickets!

Jonas ”Jones” Melgaard – Community Spotlight

We are honored to recognize Jonas "Jones" Melgaard as our April 2025…

Kudos to the March Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 294,095 Super User 2025 Season 1

#2
Martin Dráb Profile Picture

Martin Dráb 232,866 Most Valuable Professional

#3
nmaenpaa Profile Picture

nmaenpaa 101,158 Moderator

Leaderboard

Product updates

Dynamics 365 release plans