Pivotier - The RIGHT report writer for Microsoft Dynamics NAV

Pivotier is a reporting tool that works with Microsoft SQL Server to enable Microsoft Dynamics NAV (Navision) users to create ad-hoc and financial reports without any programming expertise.

For a decade Dynamics NAV end users have been struggling to easily draw data from within their Dynamics NAV application to create substantial reports without any development being required. The ability to see all fields from c/side tables has required advanced programming, has been almost impossible, or has required expensive external analytical or reporting applications.

Pivotier has been developed to overcome these reporting issues by using the latest in Microsoft reporting technologies, ensuring that Dynamics NAV data nuances such as flowfield, language captions, option text and boolean text are all translated for use by SQL Server.

Pivotier is easy to install and learn, users can start using the software quickly without any programming knowledge.

PIVOTIER PROVIDES

· Ad-hoc reports against c/side table or field without any programming knowledge
· Charts and Indicators
· Financials with dynamic pages, rows and columns
· Queries to simplify report definition and to assist in generating complex SQL statements and reports
· Enforcement of Dynamics NAV security roles

BUSINESS BENEFITS

· Empower end users to create new reports
· Report against any C/SIDE table or field securely
· Visualise data with colour, charts and indicators
· Runs reports 15-30 times faster than standard Microsoft Dynamics NAV reports
· Pivotier reports are in real time, so data will never be static
· Connect to other Microsoft reporting tools directly
· Publish to Mail, Excel, PDF and SSRS
· Web report access for casual users at a low cost

The two main reports that can be created are -

Ad Hoc Report Designer – use query definitions to generate reports using the SQL Report Viewer and incorporate advanced RDL controls for sorting and organising data while incorporating charts and graphical indicators to improve data visualisation.

Financial Report Designer – generate “out‐of‐the‐box” financials based on chart of accounts, account schedule and dimension data with the ability to dynamically create new pages, rows and columns.

For further product and pricing information, please contact us on 01903 241628, alternatively you can email us at qssdinfo@qssd.com.