Hello all,
I am using Jet Report Excel Add-ins version 24.2.0.1522 with D365 BC for extracting budget information.
The connection is fine but it keeps to prompt the error message "Our report execution has encountered inconsistent data, which indicates that data may have changed while the report was running...."
Anyone can advise ?
Thank you very much
Hello all,
Additional information, the report was built by Jet Report version 16.x which was working well for NAV 2013.
It keeps to have such when changed to D365 BC connection.
I would reach out to insightsoftware support for this. I feel like this is a SQL error being passed through Jet to make it seem like it is a Jet error. Most searches on the internet point to SSRS as the root cause.
Hi Patrick
Did you hear back from insightsoftware support?
I've just encountered this issue too but not able to log a ticket with them as my email is pending verification on their end.
In my report design, I have 2 row replicators - row 1 replicates the date from the report option by month; row 2 replicates data from jobs table.
When I run the report with the date range of 1.11.2023..31.12.2023, I get that error and the first group of results has a few rows that it is unable to display the NF values.
Observation
- it only happens for the first group irrespective of the different start date and date ranges I specify
- it works fine if I only use 1 NL Row replicator to display jobs results (although this isn't the outcome I'm after)
Report looks at BC data source, and I'd recently updated my Jet Add-in to 24.2.0.1522 because v23 was giving me the black diamond with ? in it also isolated in the first grouping of my output.