O'Reilly logo

Building Dashboards with Microsoft Dynamics GP 2016 - Second Edition by Mark Polino, Belinda Allen

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

What is Table Builder?

Before we start with the Jet Table Builder, let's review the definition of an Excel table. A table in Excel is similar to a mini database in Excel. Each row contains one and only one record, and all rows and columns are related to each other and work as one. Using a range of data in a single group (or grid), the data is easier to manage and use in other Excel features such as PivotTables. Jet Express for Excel provides us with the ability to create table directly from our GP data.

Tip

GP usually stores open, work, and history data in different tables. This is another great reason to use views. A view can be created to access all these tables so that you can have all corresponding data on the same report without having to link ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required