Pivotier enables Microsoft Dynamics NAV users & consultants to create ad-hoc and financial reports without any programming expertise. Now any Dynamics NAV customer using the SQL Server database can enjoy rich-content reports without learning any new applications with NAV database versions 4 or newer. Report output can be sent directly to Microsoft Excel, Adobe PDF, SSRS or to email recipient(s).

Pivotier uses the power of the latest Microsoft reporting technologies such as Report Definition Language (RDL), SQL Server Reporting Services (SSRS) and Visual Studio Report Designer to thoroughly modernize NAV reports. These modern Microsoft tools are completely integrated into the Classic and/or Role-tailored user experience and Pivotier ensures that NAV's data nuances such as flowfields, language captions, option fields and boolean fields are translated for use by SQL Server. More>>

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.

Pivotier makes report design simple by:

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. More>>

Financial and accounting personnel can produce dynamic pages, rows and columns based on their Chart of Accounts and Dimension values. New reports can be generated easily by entering account and dimension filters and selecting combinations of column options including budget, prior year, prior period and year-to-date.

Dimensions can be invoked without any need for additional cumbersome steps such as creating data warehouses or Analysis Views. Existing Account Schedules and Column Layouts can also be rendered using Pivotier with rich formatting options for colors, fonts, headers and footers.

And naturally, any financial report can be published directly to Microsoft Excel, Adobe PDF, SSRS and email recipients. More>>

Developers can now use modern, versatile and powerful Microsoft report designers such as Visual Studio Report Designer, SSRS Report Builder and SQL Server Reporting Services. Pivotier seamlessly integrates NAV data to these external tools and handles all NAV data "nuances" such as flowfields, option fields, boolean fields, as well as multi-language captions and 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. More>>

Casual users can now easily and inexpensively access critical reports using the web-based SQL Server Reporting Services (SSRS) application. Dynamics NAV customers can now get real benefits from their investment in Microsoft server technologies such as SQL Server and SSRS.

Pivotier's ad-hoc, financial (including Account Schedules) and Visual Studio reports can be published using RDL to SSRS, and then allow non-NAV users to run reports using their web browser. Customers can also take advantage of existing Microsoft capabilities and features to schedule and distribute reports automatically.

Extend the power and benefits of your Dynamics NAV database across your enterprise immediately! More>>