Skip to main content

Notifications

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) / Allign report row &quo...
Microsoft Dynamics AX (Archived)

Allign report row "related" data from different tables

(0) ShareShare
ReportReport
Posted on by PhilSM 270

I have a report based on

InventCostTrans

  >InventTrans

    >PurchLine

Relations are defined as InventTransId between tables

When the report runs the InventTrans and PurchLine data for the first row appears on the second row and continues to be one row out.

example:

ItemNo for A        <BLANK>

ItemNo for B        ItemName for A

ItemNo for C        ItemName for B

etc

I have attached a report where I have added the InventTransId to the end of the report page (right) to show the misalignment as it isn't clear in the report that the data is not correct.

Any ideas what I am doing wrong ?

*This post is locked for comments

  • Verified answer
    Community Member Profile Picture
    Community Member on at
    Re: Allign report row "related" data from different tables

    This problem is cause by your report's design structure.  Be aware the the report fetch's each table in the execute section method.  

    Restructure your report's design as follows:

    Body:InventCostTrans   (Table Property=InventCostTrans, No fields - just the body)

    Body:InventTrans           (Table Property=InventTrans, No  fields)

    Body:PurchLine             (Talbe Property=PurchLine - place all your fields in this body)

    The report will then call

    Body:InventCostTrans/methods/execute section to read the correct InventCostTrans record

    Body:InventTrans/methods/execute section to read the correct InventTrans record

    and finally

    Body:PurchLine/methods/execute section to read the correct PurchLine record

    Once the report enters the last body, fields can be added from any of the data source tables and will show the correct values.

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 Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics AX (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 100 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 48

#3
shanawaz davood basha Profile Picture

shanawaz davood basha 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans