• Overview
    »
  • Ad-hoc reports
    »
  • Financial reports
    »
  • Developer tools
    »

Pivotier - NAV Reporting Future is Now!

Pivotier™ allows Microsoft Dynamics NAV users & consultants to create ad-hoc and financial reports without any programming expertise. Pivotier uses the power of the latest – and true - Microsoft reporting technologies like Report Definition Language (RDL) and SQL Server Reporting Services (SSRS) to improve developer productivity. All of this with SQL Server database versions from 4.x upwards in familiar Classic or Role-tailored NAV user interfaces.

Now any Dynamics NAV customer using the SQL Server database can enjoy rich-content reports without learning any new applications or being forced to upgrade to NAV 2009. 
 

Ad-hoc reports

Create visually stunning ad-hoc reports from Microsoft Dynamics NAV without any need for expensive programming resources or knowledge. Reports can be produced from any C/SIDE table and field including any customizations and ISV solutions.

  1. Simplifying data through with pre-defined queries which present common views of business data,
  2. Adding data visualization tools such as charts and indicators,
  3. Exposing the richness of Report Definition Language through NAV-based style sheets
  4. Protecting sensitive data by respecting NAV roles and permissions.

Financial reports

Financial reporting is made easier for Microsoft Dynamics NAV because Pivotier addresses the following critical success factors:

  1. Reports can be started once your G/L Account and Dimension set-up is completed
  2. Font formatting is available to prescribe colors, treatment of negative numbers, etc.
  3. All your dimensions can be used without creating Analysis Views
  4. Enable reports for “casual” users via the web
     

Developer tools

Developers can now use modern, versatile and powerful Microsoft tools such as Visual Studio Report Designer, SSRS Report Builder and SQL Server Reporting Services. Pivotier integrates NAV data to these tools and handles all NAV data "nuances" (flowfields,option/boolean fields,multi-language captions,currency formats). Pivotier provides the following developer aids:
  1. NAV Query definition to define table relationships (i.e. joins) and field selections,
  2. Automatic generation of Transact-SQL, SQL views, data sets and SSRS Report Models,
  3. Design and run-time evaluation of filters and options,
  4. Direct integration from NAV to Visual Studio for report design and execution.