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

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Query DataSet not returning values

(0) ShareShare
ReportReport
Posted on by 105

Hello,

I have an AOT Query that sums quantity as per the grouping, another related datasource retrieves the description of one of the grouped fields from another table. All grouped fields and the sum field are correctly displayed. Th description is not being retrieved from the second table.

Below is the query:

5100.Query.png

Below is the result:

Results.png

Description is not being fetched from ITB_Model. Note that I have renamed the column label to "Name" instead of description.

below is the report design:

5482.Design.png

Thank you

*This post is locked for comments

I have the same question (0)
  • Verified answer
    Najib Saad Profile Picture
    105 on at
    RE: Query DataSet not returning values

    I got it figured out, I added the Description field to the Grouping and it now retrieves the value.

    I hope this thread can be useful to other users.

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#1
Martin Tocauer Profile Picture

Martin Tocauer 4

#3
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans