Scheduled Report Job Fails - Report Does Not Have DataItem Which Uses Table

(0) Share

Report

Posted on by Community Member

I created and schedules a Customer Top 10 Report. If I run this report, either by scheduling or using the RUN button on the Job Queue ribbon, I receive an error "The Customer - Top 10 List report does not have a DataItem that uses the table..." This happens with any report I have tested so far. The reports run okay if I run interactively and not from the Job queue.

*This post is locked for comments

I have the same question (0)

All responses (5)

Answers (0)

Suggested answer

Community Member on at

Like (0)

Report

Hello Steve,

Check the data item in the report design mode. and check also if the table exists.

Hope these link help.

https://dynamicsuser.net/nav/f/technical/68574/dataitem-doesnt-exist

https://dynamicsuser.net/nav/f/developers/33197/changed-main-dataitem-on-a-report-and-now-cannot-call-using-report-run

Thanks.

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Charles,

Thank you for taking the time to respond to my question. This is not a custom report. It out-of-the-box 2017. And the report runs ok if I select it from the reports menu. It fails only if I run from the Job Queue.

Steve

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (0)

Report

Can you please post a screenshot of your NAS configuration?

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Stefano,

Thank you for taking the time to post. Here is what I could find of the NAS configuration:

Steve

Was this reply helpful? Yes No
Suggested answer

Stefano Demiliani 37,166 Most Valuable Professional on at

Like (1)

Report

Ok. As supposed, the NAS is not properly configured (it’s not active).

Check this post for configuring it:

[View:https://www.encorebusiness.com/blog/dynamics-nav-job-queue/]

Was this reply helpful? Yes No