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

Author:Belinda Allen & Mark Polino [Allen, Belinda]
Language: eng
Format: azw3
Publisher: Packt Publishing
Published: 2017-03-10T05:00:00+00:00

Now, that we have begun the layout of our balance sheet using Excel, let's start adding some Jet functionality. You'll notice that we began adding information several rows down and several columns from the left. Jet uses, at a minimum, the first row and the first column for functions and formatting. I like to highlight the rows and columns Jet uses, so when I am in the Design mode, I can easily see what is visible and what is not visible when the finished report (Report mode) is displayed.

Highlight columns A and B and highlight (Home | Font | Fill Color). Highlight row 1 and highlight (Home | Font | Fill Color). As I mentioned earlier, I like to highlight the columns that will be used for Jet functions and hidden so when I am building the design of the report, I know where I can hide cells and where I can make cells visible.

Verify Excel is pointing to the sample company data, Fabrikam, Inc. (Jet | Settings). In case you are wondering, this is how you will change the company data that is being displayed in the report:

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.