Using this on ledger entries could cause an issue when there are multiple tranactions with the same account and date. In previous versions of Jet, it would only return unique values.įor example, querying the customer table for “City” and “State”, would only return 1 set of data, in other words it would ‘group’ the results.
This means when set to TRUE, it will return a row for every record in the base table. This enables easier maintenance and setting up of new users.Ī new “IncludeDuplicates=” keyword has been added to the NL(Table) query. 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 new version makes it easier to deploy to a large number of users. The Table Builder lets you easily create excel tables using Excel’s powerful PivotTable and PivotChart functionality to create interactive reports. Jet Reports can connect to any OLE/ODBC compliant 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. The Table Builder has been improved to work with “Universal” data source. In this blog post I will discuss some great new features now available in Jet Reports 2013. The Excel based reporting solution for Microsoft Dynamics NAV includes new features and improved performance. Jet Reports 2013 is much faster than previous versions and is fully supported with NAV 2013 R2. Jet Reports has recently released two new versions, Jet Essentials 2013 and Jet Express for NAV 2013.
0 kommentar(er)
