Hi,
As mentioned in the title, we have updated our Jet Report and after this when we run all reports we got error cells with #value! This error appears randomly on different cells of different report. Example first run, cell B1 at #value and we run it again and it's now J14 and B1 is correct. Other when I use the Check Error button 100% of the time the cell is correcting. The error happens with both NF and NL. We have no idea what the source of the problem is, can someone help us?
Typically this has to do with the queries timing out during the run phase. I would reach out to Support via the Customer Portal . I think an initial solution would be to increase your time out settings (maybe double it) to see if that solves the issue but Support might have other ideas.
Same problem here.
Where can we find the timeout settings?
We change the sql server authentification from Windows Aunthentification to Sql server authentification and that fix our problems
