Dynamics NAV offers several ways of analyzing and reporting data inside the application. If that is not enough, you can also extract data from the application and use external tools to report and analyze your data.
In this section, we will see the different ways you can extract your data from Dynamics NAV. Once it is outside the application, you can use the most convenient tool for you.
Data in Dynamics NAV can be extracted in multiple ways. The various ways include:
Copying and pasting to Excel
Extracting data through SQL Server
Any external data/reporting tools that can connect to SQL Server
Web services
EDI
In this section, we'll focus only on two ways of exporting the data:
Sending data to Microsoft Office applications
Using web services