#Jet reports express for microsoft dynamics nav how to#
#Jet reports express for microsoft dynamics nav install#

#Jet reports express for microsoft dynamics nav how to#

With this you can set specific dates and times for the reports to run, the report can then be sent to a selected group of email addresses.ДЇor more information check out our YouTube Channel where you can find our other Microsoft Dynamics NAV & Dynamics 365 Business Central Tips videos to learn discover what other features are being underutilised and how to overcome your recurring issues here. If you notice slowdown during the running of Jet Reports, it may be worth utilising the Jet Schedular. When initially setting up PowerBI it is important that you have set filters within the Query Editor to reduce the amount of data that needs to be brought across from Dynamics NAV.

In this case simply select вЂSet on HoldвЂ™ and change the start time to a more convenient time when the system isnвЂ™t being used intensivelyД«oth PowerBI and Jet are fantastic reporting tools, but if not used correctly can cause slowdown.

If you notice that you have issues at a certain time of the day, it may be worth checking Job Queue Entries, if you see an entry with a status of вЂIn ProcessвЂ™ and the User session was started some time ago this may be the cause of the issue. We would always advise against users exiting their sessions whilst a report is being run even if Dynamics NAV appears to not be responding.ДЄ key use for job queues is to run lengthy processes that would typically lock the system out of hours. Once the report is finished you should notice a significant improvement in performance and your table locking issues should clear. If you do find that a user is running a large report, one option would be to cancel the report, if not the other option would be to let it run its course.

We offer this service for all versions of Navision/ Dynamics Nav though if you are using an. Create the report in Excel from the Jet add in menu group.

Create a link within the Jet Excel Add in to the Dynamics Nav database.

#Jet reports express for microsoft dynamics nav install#

We would always recommend running reports that take an extended amount of time out of core work hours. The steps to get Jet up and running are straight forward: Install the jet application on each user's Excel application. What вЂlarge reportsвЂ™ are we referring to? Financial reports tend to be the main cause, such as the Customer Statements and Inventory Valuation Reports. This is often the main culprit for slowdown. If so, here are a few things you can check

When speaking to our customers, two of the most common queries are вЂWhy is our system slow?вЂ™ and вЂWhy do we get Table Locking errors?вЂ™ Sometimes these issues may occur outside of TecmanвЂ™s support hours.