
Building Dashboards with Microsoft Dynamics GP 2016
By :

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.
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 the tables together yourself. If you create an incorrect link, your data will not be correct.
Now, let's do what we came to do here: write a report in Excel. In the next chapter, we'll build some financials statements...
Change the font size
Change margin width
Change background colour