I have a report that the first time I run it always fills in a value in the first cell and #value on all other cells on the report but then if I run it a second time it works. It does this every time and for all users. It is the latest version of Jet reports pointing to Business Central in the cloud
One possibility is that the connection between your computer and your Business Central database is taking a while to establish.
I would suggest submitting a request to Jet Technical Support. They may have other idea and/or may have you create a log file to see what's going on behind the scenes.
The strange thing is this report take only about 3 minutes to run. I have others that take 15 minutes with no issues. I also ran it again and which I click on any field that has #Value and asked the system to check the error it replaces the #value with the right number.
I will ask Jet support for help
We are experiencing a similar issue.
Majority of our reports are returning with #Value and other times the report returns with data. We migrated our ERP which is being hosted in the Cloud (Azure). We have noticed this issue since the migration and have gone as far as having our vendor create an instance (Server) specifically for Jet Reports, but we are still receiving the #value errors and it is impossible for us to Debug each row within the report.
We have also observed reports that should take 15mins to run only takes 12sec and returns with the #value.
Did anyone get final resolve on this from Jet Support? I'm running into the same issue. Seems to only be a problem when I am referencing G/L Entries but that could be a coincidence.
We had a similar issue with the #Value!, but resolved by clicking "Check Error" for each individual cell. would newer build of Jet resolved this?