I have a user that runs one particular report that never works on the first try and it will run for 10 minutes. After the report returns nothing, she can run it a second time and it runs fine and within 2 minutes.
What could be causing this?
I've attached the errors that the user is getting on the first try.
Jet Report Issue - 2nd Try report.docx
Date
Votes
3 comments
-
Jet Reports Historic Posts The connection to your DB may be bad, the OLE is probably telling you that your connection timed out. I would start by looking at the coding that is in cell $B$8, or whatever cell is it as shown in the second image, and see if its something in that cell causing the error in particular. Troubleshoot by droping the code into a fresh spreadsheet and see what happens.
Another thought, realted directly to the report working the second time. Is the person that runs the report opening it in designer mode and is only a viewer? Maybe that is causing the error on first run. -
Jet Reports Historic Posts In our environment, the error you described occurs when we run complex reports during high user activity. Put it on the scheduler and run it at night.
-
Jet Reports Historic Posts Another thought, if your using NAV, make sure that C/Front is up to date with the version of Jet you are using. Use this link to see compatibility list http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=452
Please sign in to leave a comment.