Cost Control is please to offer “Pivotier Report Writer” as an additional reporting tool for Dynamics NAV. Read this blog, and leave a comment below.
How it Works?
- Pivotier queries are defined by IT or power users to handle the joining of tables and fields. Queries handle the interpretation of NAV flowfields and other data nuances automatically by generating Transact SQL statements at run-time. Queries also provide a level of data security and optimization of data reads to your SQL Server database.
- End-users define ad-hoc reports within Dynamics NAV using EITHER the Classic or Role-Tailored (i,e, NAV 2009) user interface and select fields from pre-defined queries. The query definition greatly simplifies the user experience by eliminating the need for end-users to understand complex data relationships within the NAV database.
- Calculated columns, graphical data indicators and charts can be added with a few mouse-clicks to generate rich, colorful and visually stunning reports.
- Reports can be shared with other users in the enterprise using NAV security roles.
- Reports can also be published to Excel, PDF or to SSRS.
Encouraging End-users to Create Reports
Users are often confused and intimidated by the vast array of tables and fields available in Dynamics NAV and its many add-on solutions. They prefer to work within their familiar Classic or Role-tailored NAV interface and resist using external applications like Excel. Pivotier allows IT departments and partners to define Queries which join multiple tables and fields in normalized data sets to match specific business objectives such as sales reporting or employee analysis. Now users can simply pick fields and place them on reports without any knowledge of internal data complexities.
We recently hosted a Webinar to show our customers how this reporting tool worked. We invite you to watch this replay to see what you think too. Please leave a comment as to your opinions. Warning, this is a full 60 min presentation of all the details.
Allocate the time before you begin, there is lots to learn: (30 Seconds to open)