Jet Reports has recently released two new versions, Jet Essentials 2013 and Jet Express for NAV 2013. Jet Reports 2013 is much faster than previous versions and is fully supported with NAV 2013 R2. The Excel based reporting solution for Microsoft Dynamics NAV includes new features and improved performance.
In this blog post I will discuss some great new features now available in Jet Reports 2013.
The Table Builder
The Table Builder has been improved to work with “Universal” data source. This means that you can connect Jet to any SQL database, and create reports using SQL Views in addition to the table builder. Jet Reports can connect to any OLE/ODBC compliant data source.
The Table Builder lets you easily create excel tables using Excel’s powerful PivotTable and PivotChart functionality to create interactive reports.
This new version makes it easier to deploy to a large number of users. The Jet Configuration Service and Administration Console allows company administrators to configure and manage their Jet data source settings for all users in a single location. This enables easier maintenance and setting up of new users.
Now to get more technical.
A new “IncludeDuplicates=” keyword has been added to the NL(Table) query. This means when set to TRUE, it will return a row for every record in the base table.
In previous versions of Jet, it would only return unique values.
For example, querying the customer table for “City” and “State”, would only return 1 set of data, in other words it would ‘group’ the results.
Using this on ledger entries could cause an issue when there are multiple tranactions with the same account and date. Now, adding this IncludeDuplicates=True, eliminates this issue.
A nice new feature in Jet Reports 2013 is the ability to add Tooltips to the Report Options Window.
Tooltips are text boxes that appear when you hover over the value providing users with additional information about their options.
You can create a tooltip by entering “tooltip” in row 1 of the options panel. See the image below.
Another feature that make life easier is the ability to hide tables with no records. It also shows the table number and number of records.
In the image below you can see the Customer table contains 1086 records.
By Daniel Argus, Senior ERP Consultant at Evolution Business Systems.
Call Daniel Argus on 1300 303 973 to find out how your business can benefit from Jet Reports 2013.
About Evolution Business Systems (EBS) https://www.mynavcloud.com.au
Subscribe to the EBS monthly enewsletter to get the latest Microsoft Dynamics NAV, Arrow Financials news and more. EBS enews.
Evolution Business Systems (EBS) specialises in business management solutions that give you the freedom to focus on your business. Melbourne based EBS does this by automating your core business processes and integrating your specialist business applications to deliver the right financial management solution. With deep expertise in leading financial applications including Microsoft Dynamics NAV and Arrow Financials, EBS works beside clients to ensure their software solves problems rather than creating more. EBS has a detailed implementation strategy that is tailored to customers in terms of timelines, requirements, risks and responsibilities. While it does not sell or support hardware or site network environments, EBS informally partners with selected specialists in these areas to provide clients with a “total solution”.