now it happened twice, so I decided to write a post on this forum.
Steps:
I created a new EDT
I edited the RDP header table of the PurchaseOrder, adding a field of type of the new EDT
I updated the report DS from VS
I added a new field to the report (the created at step 2)
Deploy successfully the report
When I launch the report, it gives me an error, saying it cannot find the new field. Actually in the database the field exists and it has also been pupulated!
I added new fields to tmp table, it works fine in our DEV environment, but when it is transfered to test environment, it said the new field cannot find it in the tmp table, and the funny thing is all the setup are English, but the message I got it is in Danish.
I generated FULL CIL, and restart the sql report server, it did not help.
Any advice and suggestions will be greatly appreciated!
The solution for this is, once we are introducing a new field to a existing database the SSRS report configuration manager is not getting refreshed. This is a common problem when all (AX APPLICATION, SQL. …) are installed in different BOX. So the SSRS report manager is not refreshed with the new field. Once you restart the SSRS configuration manager then it will Synchronize with the database and will get the latest changes.
If this didn’t work for any one the last and 100% solution is to restart the AOS. this will work.