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

september

01sep10:00 am10:30 amEnsuring Quality and Compliance for Batch Manufacturers in Life Sciences

01sep12:00 pm12:30 pmIs it Worth It to Move to the Cloud? A Look at Considerations for Current Agribusinesses Using Dynamics GP

01sep2:00 pm2:45 pmWhat’s New in Dynamics 365 Finance and Supply Chain

09sep11:00 am12:00 pmConfab Live with Stoneridge – Data Strategy and Reporting – Mining Decision Making Insights

15sep10:00 am11:00 amSolving the Biggest Challenges in Agribusiness Through Innovation and Technology

22sep12:00 am12:30 pmSimplifying Payroll and HR Management with ADP Workforce Now

22sep10:00 am10:30 amStreamlining Batch Manufacturing with Technology

22sep2:00 pm2:30 pmProcess Automation for Microsoft Dynamics D365 for Business Central, Finance and Operations and GP

23sep11:00 am12:00 pmConfab LIVE with Stoneridge - Riding the Wave 2 Release – Key Features Coming to Dynamics 365 this October

29sep10:00 am11:00 amTop Five Reasons Why NOW is the Right Time to Move from Salesforce to Dynamics 365 Customer Engagement

29sep12:00 pm12:45 pmUnderstanding Job Costing and Tax Management in Business Central

29sep2:00 pm3:00 pmDigitalizing Horticulture & Agriculture - How to Sell Plants Online and Simplify Business Management

30sep12:00 pm4:00 pmSecurity and Permissions Training for D365 Business Central or Dynamics NAV

october

06oct10:00 am10:30 amPreview of D365 Business Central Fall Release Features and Functionality

06oct12:00 pm12:30 pmInsider's Guide to New Features Available in the Fall Release of D365 Finance and Supply Chain

07oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Technical

21oct11:00 am12:00 pmConfab LIVE with Stoneridge - Dataverse and Dynamics in Review – Let’s Get Functional

26oct(oct 26)9:00 am28(oct 28)5:00 pmStoneridge Connect Leadership and Community Conference

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