TECHNOLOGIES
  • Report Defin. Language
  • SSRS Report Distribution 
  • Visual Studio Datasets
  • Report Models
SYSTEM REQUIREMENTS
  • SQL Server 2005/2008
  • Database NAV 4.X +
  • Executable NAV5.0 sp1 +
OPTIONAL REQUIREMENTS
  • SQL Server Reporting Services (SSRS)
  • Visual Studio

UNLEASHING THE POWER OF SSRS AND RDL

Microsoft Dynamics NAV end-users and consultants can now generate ad hoc and financial reports without any programming expertise. Pivotier interprets and publishes Dynamics NAV data including flowfields and option fields for use by SSRS components. Developers can start using modern Microsoft report designers like Visual Studio instead of C/SIDE as Pivotier connects NAV users and data seamlessly to these tools.

Pivotier automatically generates SQL, report definition language (RDL), SQL Views, NAV datasets, SSRS reports and SSRS report models (SMDL), hence eliminating the need for NAV users to learn new languages or applications.

Reports are rendered in Microsoft’s local and web Report Viewers with advanced controls for charts, indicators (KPIs), font properties, sorting columns and collapsing detail. 
All Pivotier reports can be sent by e-mail, or exported to Excel, pdf and SQL-reporting services.