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 relation betwee...
Microsoft Dynamics AX (Archived)

how to relation between tow tables in visual studio ?

(0) ShareShare
ReportReport
Posted on by Hawra 786

I'm create tow tables in visual studio for report so how I do relation between table 1 and 2 because table 1 for header and table 2 for body ?

Please help me!!

 

http://store1.up-00.com/2015-02/1423770918371.png

 

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    syed baber Profile Picture
    syed baber 11,633 on at

    Hi Hawra,

    Table relations needs to be specified in AOT query and then you can use that query in your SSRS report in Visual Studio. So, you can create query based report by specifying the data source type as query and specify the query you created in AOT.

    Please verify and let me know if you have further queries in this regard.

    Thanks,

    Baber.

  • dolee Profile Picture
    dolee 11,279 on at

    Hi Hawra,

    What are you trying to achieve?

    When the report is printed. The table on the top will print all records from header datasource, then afterwards the bottom table will print all records from the body datasource. What behavior you are expecting with a relation between the two tables?

  • Hawra Profile Picture
    Hawra 786 on at

    Hi Baby

    yes i'm ordey create relation between the tables in AOT but i want print this report for multiple customers in same time ( From date .. TO Date ) so I want to make prints information for customer Such as name, address and phone number in table 1 also print the details for sales order for the same customer in table 2 ..

    please see the link m i'm try make same this put for the different customer in same time . ( Depends on the filter From Date ... To Date )

    store1.up-00.com/.../1423809585341.gif

  • Hawra Profile Picture
    Hawra 786 on at

    Hi kind regards ,

    No , not  same that . i want print this report for multiple customers in same time ( From date .. TO Date ) so I want to make prints information for customer Such as name, address and phone number in table 1 also print the details for sales order for the same customer in table 2 ..

    please see the link m i'm try make same this put for the different customer in same time . ( Depends on the filter From Date ... To Date )

    store1.up-00.com/.../1423809585341.gif

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!

Congratulations to our 2025 Community Spotlights

Thanks to all of our 2025 Community Spotlight stars!

Congratulations to the February Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Alexey Lekanov Profile Picture

Alexey Lekanov 2

#2
Henrik Nordlöf Profile Picture

Henrik Nordlöf 2 User Group Leader

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans