Getting Started with Jet Express for Dynamics NAV, Dynamics AX and Dynamics GP

by | Updated August 15, 2016 | Dynamics NAV, Reporting

Jet Reports is a complete reporting tool that connects to databases in Microsoft Dynamics AX, NAV, and GP. More than 137,000 users and 10,000 companies currently use Jet Reports, spanning more than 90 countries. It offers three tiers of functionality: Jet Express (free), Jet Professional, and Jet Enterprise. Jet Professional and Jet Enterprise offer functionality for more complex reporting needs. Jet Express however, is a convenient and easy-to-use add-on to Microsoft Excel that can easily connect to your Dynamics NAV, AX or GP database to run real-time reports. Today, we will be focusing solely on running a simple report in Jet Express.

Downloading Jet Express

1.       Go to https://www.jetreports.com/jet-express/

2.       Select your platform: NAV or GP

3.       Scroll down and click “Download Now”

4.       Fill out the form on the right and click “Access Resource”

5.       Click the link in your email to download Jet Express Setup

6.       Follow the prompts in the Setup and select the “Launch Jet Reports” checkbox before clicking Finish

You should now have an Excel window open with a new tab on your ribbon labeled “Jet”. The next step is to connect to your NAV database. Click the Jet tab, and then click Data Source Settings in the Settings group.

Jet Data Source Settings

Configure the fields on the Connection tab to connect. Once the correct server is listed, the Database and Company values should be available in the dropdown menus.

Data Source Settings

Building a Report

To build your report, click the Table Builder button in the Design Tools category. Next, choose the table that houses the data you wish to see by clicking the “Add a Table” button. From here, you can choose which fields you wish to display when your report runs. They can also be searched on when your table is selected. Simply check the box of the field to add it to your report.

Table Builder

Linking Tables

You aren’t restricted to simply reporting on one table at a time. To link another table to the existing table, highlight the source table under “Tables” and click the “Add Table” button. Once the added table appears in the “Tables” section and is highlighted, you can choose which fields map to each other between the tables in the Links section at the bottom of the main window pane. Most of the time, Jet can guess which fields match to each other and will auto-populate them. If not, you can manually select the two fields to add the link. Now that your second table is added, you can add fields from this table to display.

Table Builder G/L Account

Ordering the Display Columns

Once your fields are selected you can move around the order of how they’ll be displayed by dragging around their boxes on the header into the correct sequence.

Filtering

Filtering is an important feature of reporting. In order to filter on a value, click on the table name below the “Tables” header. Click “Add Filter” and then choose a field you would like to filter on. Any field can be filtered on, not just the ones displayed. If you wish to run this exact report multiple times or in the future with different parameters, click the “User Defined” checkbox on the right side of the box. This means users will be able to change these filter parameters after the report is created and before it is re-run in future iterations. From there click OK to finalize your report.

IMPORTANT CAVEAT: When using Jet Express, you cannot save your report layout template in Table Builder to modify for future use. This is one advantage of upgrading to Jet Professional. Once you click OK, you will need to start from scratch to build the report over again.

Table Builder Filter

You should now see cells filled in with the “guts” of your report. If you understand what the cells mean, you can modify your report to rerun with different fields and parameters, but for now we will not pay any attention to these cells. To run your report, click the Report button on the left side of the Jet ribbon. If you’ve marked any filters as “User Defined” you’ll see them pop up with the ability to change their values before the report runs.

Report Options

Now that you have your report in table form, you can do whatever you wish with it. Filter it. Sort it. Add other columns to add custom formulas. Convert it into a PivotTable with slicers for easy filtering. However, the next time you click Refresh to rerun the report, everything on this sheet will be removed and replaced with the updated data. Again, Jet Express is primarily used for ad-hoc reports rather than total report automation.

So there you have it. You’ve now made a report in Jet Express! Congratulations are in order.

Related Posts

3 Comments

  1. Jakob

    Hi – I’m using AX – do you know anything like Jet Express to use for AX?

  2. Brandon Carmichael

    Hello Jakob,

    I reached out to Jack as I had no idea myself – he informed me that he followed up with someone at Jet to see if they had any suggestions. Unfortunately, he did not know of anything comparable to Jet Express.

    Sorry,
    Brandon

  3. Wes

    Awesome quick presentation of how to get the basic reports to work.

Submit a Comment

Your email address will not be published. Required fields are marked *

Upcoming Events

november

05nov11:00 am12:00 pmConfab with Stoneridge - Livestream - Project Oakdale: The NEW Integration of Power Platform into Teams

18nov10:00 am10:30 amThe Modern Manufacturer - Tears and Trauma of MRP

19nov11:00 am12:00 pmConfab with Stoneridge - Livestream - Project Oaktree: NEW Functionality for Dynamics 365 Manufacturing

december

02dec9:00 am12:00 pmOnline Workshop - Dynamics GP Year End Close (Morning Session)

03dec11:00 am12:00 pmConfab with Stoneridge - Livestream: Live Agents, Power Virtual Agents, Omnichannel – Oh My!

03dec1:00 pm4:00 pmOnline Workshop - Dynamics GP Year End Close (Afternoon Session)

09dec10:00 am10:30 amThe Modern Manufacturer - Manufacturing Policy Management

17dec11:00 am12:00 pmConfab with Stoneridge - Livestream - Technology in 2020: A Year in Review

About Stoneridge
Stoneridge Software is a unique Microsoft Gold Partner, with emphasis on partner. With specialties in Microsoft Dynamics 365, Microsoft Dynamics AX, Microsoft Dynamics NAV, Microsoft Dynamics GP and Microsoft Dynamics CRM, we focus on attracting the most knowledgeable experts in the field to our team, and prioritize delivering stellar solutions with maximum impact for your business. At Stoneridge, we are deeply committed to your results. Each engagement is met with a dedicated team, ready to provide thorough, tailored, and expert service. Based in Minnesota, we intentionally “step into your shoes,” wherever you are. We focus on what you care about, and develop trusting, long-term relationships with our clients.

Subscribe To Our Blog

Sign up to get periodic updates on the latest posts.

Thank you for subscribing!

X