Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics AX forum
Suggested answer

show two level of record in query report

Posted on by 40

how to show 2 level of record in query base report

eg;

I HAVE DONE BACHELORES,AND MASTERS FROM DIFFERENT INSTITUE

HOW TO SHOW BOTH LEVEL OF EDUCATION AND INSTITUE

  • ToddB Profile Picture
    ToddB on at
    RE: show two level of record in query report

    Hi asadfaiq,

    If you are still working on this can you post your existing query that only shows the latest record?

  • asadfaiq Profile Picture
    asadfaiq 40 on at
    RE: show two level of record in query report

    i have made a query that show only latest record i.e it shows my masters record

    and I want to show both record masters and bachelors

    in query based report

  • Suggested answer
    ergun sahin Profile Picture
    ergun sahin 8,812 Super User on at
    RE: show two level of record in query report

    I don't know the relationships between tables and records but You can look for adding dataset or union query

    docs.microsoft.com/.../defining-report-data

    docs.microsoft.com/.../how-to-combine-data-sources-in-a-union-query

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 288,420 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,672 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans