Best Practices - G/L Report Performance with NAV 2013


Jet Essentials offers the user a great deal of design flexibility. Using Excel's formatting capability, you can have almost unlimited potential for determining how your reports will look. You also have a great deal of flexibility on how you use Jet Essentials' capabilities to find and display the data for your report.

There are certain methods, however, that work better (and faster) than others. Let's look at a common example using a simple G/L-Balance report.


[size=150]Static Report - slower[/size]
One common type of report is what is call a "Static Report". In a static report, much of the information is already entered in the report by hand, and then other information is drawn from the database.

In this example:

All of the account numbers and names we are wanting to see have been entered by hand. Then, the Jet Essentials GL() function has been used to just compute the current balance of each account from our NAV 2013 data source. Running this report would result in one query being sent to that data source for each account displayed in our report.

Before we run this report, let's look at another way we could design it so that we can compare the two methods.

[size=150]Replicating Report - faster[/size]
In this example, an Essentials' NL("Rows") function has been used to gather all the account numbers we want to see:

In the next column, we get the name of each of those accounts:

And finally, just as in the Static example, the GL() function is used to compute the current balance of the account.

Each line of this example involves three separate Jet Essentials functions [one each of: NL(Rows), NL(First), and a GL() function].

Given that this example uses 3 Jet functions for each account (as compared to 1 Jet function for the Static example), you would probably expect this method to take 3 times as long to run as the Static example.

Excel and most databases - including Dynamics NAV - are able to perform calculations very quickly. Much of the time involved in reporting is taken up by the communications between the database and the reporting tool that is requesting the information.

Jet Essentials (staring with Essentials 2013) includes a "Function Optimization" feature that is able to optimize various aspects of Replicating-type reports in order to minimize the amount of data that has to flow back and forth between Jet Essentials and the NAV data source.

With our sample NAV 2013 database, the replicating method generated the same results as did the static example - but took 97% less time to do so.

The combination of Jet Essentials and Excel provides you with great flexibility for how to design your reports.

Keep in mind, however, that some design strategies work better than others.

[size=200]Additional Resources[/size]
More information about report design can be found in the Jet Reports’ online Knowledgebase (http://kb.jetreports.com/).

This Community Site features dedicated Jet Essentials users and Jet Reports staff members asking questions and offering suggestions on many Jet-related topics.

Jet Reports offers a variety of Training Opportunities to help individuals and organizations who are interested in increasing their knowledge and capabilities with Jet Reports products (http://jetreports.com/customers/user-training.php).


    Please sign in to leave a comment.