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) / AOT Query -> SSRS :...
Microsoft Dynamics AX (Archived)

AOT Query -> SSRS : One of the data sources is showing blank values in my SSRS report

(0) ShareShare
ReportReport
Posted on by Momochi 1,042

Hello awesome community!

I am making an SSRS report to show the items Expiration Date. I made the following query in the next screenshot:

6177.Capture-2.PNG

The strange thing is, all the other 2 data sources (InventTrans & InventDim) are showing values in my report's table while "InventBatch" values are showing blank values in my report's table.

What is strange is that in my DP class, I added a range for the "InventBatch" table and the report does run correctly according the range assigned to the "InventBatch" data source.

I tried restarting the SQL reporting service and Dynamics Object Service but nothing happened.

I tried clearing the cache through tools sub menu too.

I tried removing the range code too and the issue still persists. 

What should I do?

Any advice would be appreciated :)

Thanks in advance!

*This post is locked for comments

I have the same question (0)
  • Martin Dráb Profile Picture
    Martin Dráb 239,069 Most Valuable Professional on at

    It seems that you're trying to test both the query and your report at the same time and then you don't know which part is wrong.

    Also, you didn't tell us anything about your report, namely whether it's based directly on the query or it is using a data provider class.

    You should split your debugging to smaller pieces. First check if your query returns what you expect. If it doesn't, there is no point in using such a query in a report, because the report will never work. If it does return the right data, you'll now that you should stop focusing on the query and rather review how you're using the data in your report.

    If you use an RDP class, you can also change it to return dummy data, which will allow you to test the report independently on the query.

    And don't forget that you may be currently getting an older version of your query, stored in SysLastValue.

  • Momochi Profile Picture
    Momochi 1,042 on at

    Hello Mr. Martin,

    I am using the query inside a DP class and the data I am getting is correct, it's just when I try to use any field in InventBatch it gives blank vlaues. But when I add a range for InventBatch using Querybuilddatasource.addRange(), it works, the query gets affected and the data is correct. But as I said, can't get any InventBatch data.

    I tested the query on the SQL server and it does return correct data and I did get data from InventBatch, but inside my DP I'm getting blanks from InventBatch.

  • Sohaib Cheema Profile Picture
    Sohaib Cheema 49,677 Super User 2026 Season 1 on at

    One thing that i can think of

    Every InventTrans will not have InventBatch, which means only those transactions can show batch number where those were processed with Batch Record. such as if you have received some inventory using batch number. I would not expect each InventTrans to have a related record for batch. Watch your join type please and also requirement of what you want to display

  • Momochi Profile Picture
    Momochi 1,042 on at

    Hi Mr. Sohaib,

    When I use InventBatch::find (itemdID, inventbatchID).ExpDate I do get data.

    But when I try to get it from the query InventBatch.ExpDate it gives me a blank ExpDate.

    It's not only ExpDate, all of InventBatch fields give blanks if I used the object from the query. While InventTrans and InventDim are working fine they give correct data.

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!

Meet the Microsoft Dynamics 365 Contact Center Champions

We are thrilled to have these Champions in our Community!

Congratulations to the March Top 10 Community Leaders

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Joris dG Profile Picture

Joris dG 5

#2
Andrew Jones a1x Profile Picture

Andrew Jones a1x 2

#3
GL-01081504-0 Profile Picture

GL-01081504-0 1

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans