End of mainstream support for Microsoft Dynamics AX 2009, 2012, and 2012Mainstream support for Dynamics AX 2009 Service Pack 1 (SP1), Dynamics AX 2012, and Dynamics AX 2012 R2 ended Oct. 9, 2018. After that date, only security hotfixes will be provided for these three versions through the extended support period that until Oct. 12, 2021. Read more
2019 release wave 2 Discover the latest updates to Dynamics 365Release overview guides and videos Release Plan | Early Access Availability
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance and Operations TechTalks | Customer Engagement TechTalks | Talent TechTalks
Hello guys, I have a very strange situation here. So, I have a user who has all the access and right to the reports(SSRS) it is normal for this user to print the inventory value report(Inventory and Warehouse Management->Reports->Status->Inventory Value->Inventory value) every month end. However, the user tried to print the report the other day and got the the following..Image below.
As you can see only the shell of the report comes out, no data is printed on the report. I am lost as to what happened and why this started happening. I delete the user from AD and re-create the user but that did not resolve the problem..... User can print other report but not this one.
Please, anyone who may have an idea why this is happening please help. Thanks much in advance.
I cannot guarantee a solution by my answer but please check two things.
1) usage data of the user, for this report, its queries and Controller class. Clear those entries only.
2) Make sure if there has been no change in the security of the user. For example the access of the temp table might not gone away, from which DataSet gets the data of the report.
Running the inventory value report requires that a inventory value report configuration ID is created and setup beforehand that is selected when running the report.
I would expect that this configuration is possibly incomplete. Can you check that?
Here is a screenshot that shows a sample setup from my demo machine
Please compare your configuration and let us know how it is setup.
Many thanks and best regards,
It's very strange, the user used to be able to run the report every month. But all of a sudden it doesn't show any data. From my limited understanding of SSRS i think the user may have lost access to the temp table... can this happen without human intervention? What is the temp table and how do I check it to see if the user has access?
Nothing should be lost without any user interaction. This sound indeed strange.
Can you - with your user account - or a colleague run the report?
When doing that can you share the parameters that you used before hitting the OK button for running the report?
Just checked the user computer and compared it with me. The invent value report parameters are the same. everything is the same.
We are using the same parameters. I am able to generate the report but he cannot. Even though 1 month ago he was able to run the report without any problem.
Can this be a caching issue or something related to the usage data of your colleage?
Have you tried running the report for this ID / configuration?
Your screenshot only shows the setup.
Hi Ludwig, I have already refresh the cache (Metadata caches on the report server have been cleared.) When you same "something related to the usage data of your colleage" what do you mean?
Here is a screenshot of the ID/configuration
I thanks you for your help.... just cant figure out why this is happening.
Try to delete all the usage data of your colleague to see if this caused the issue. Do this first in a demo environment where you can test whether it resolved the issue.
What you can also test is whether some role settings of your colleague are responsible for this. Probably test in your demo system if your colleague can see the data if he/she gets e.g. the system admin role assigned.
What might also be interesting to know is whether only one colleague is affected by this issue or multiple.
Which system role you have assigned to the user.
Good morning, user has admin role... As I mentioned before, the user has always run the report and now nothing is coming out.
I had a look at your screenshots from above and have probably a kind of 'stupid' question.
In one of your screenshots you run the inventory value report for 31 March 2019.
This was a Sunday.
Not sure if your people are working on a Sunday but can you try entering a from date 01 March and a to date 31 March or alternatively select any other working day in March?
(I am referring to this screenprint: community.dynamics.com/.../ID-Inventory-Report.PNG)
Please remove all other role and change your filter criteria based on what you have records in your table.
Also check the preview of your inventory value report configuration.
Have you tried to run the report without any filter to deduct the data problem?
Was the SSRS report server URL modified?
What do you see with the debugger? Is data really inserted in the tmp table?
Rati, to answer your questions....
There are no modification to the SSRS server URL
I have not run the debugger as am not familiar with how it works
Data is being inserted in the tmp table because everyone esle can run the report.
Hello Prashant, I will try this and let you know.... please note however that with the same parameters and ID, everyone else can run the report
I would recommend that you get a developer involved here.
It seems that you tried almost everything that is possible in the AX client and I think the fastest way to get this fixed is by debugging the issue.
Business Applications communities