O'Reilly logo

Microsoft Dynamics NAV 7 Programming Cookbook by Rakesh Raul

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Showing data in Excel using PowerPivot

PowerPivot is a free add-in to the Excel 2010 version. It extends the capabilities of the PivotTable data by introducing the ability to import data from multiple sources. In this recipe, we will design a basic report on NAV database using PowerPivot.

Getting ready

Microsoft Excel must be installed on the client machine with PowerPivot add-in.

How to do it...

  1. Start Microsoft Office Excel and select the PowerPivot Window action from the ribbon:
    How to do it...
  2. From the PowerPivot window, navigate to From Database | From SQL Server:
  3. Provide the connection name and select SQL Server where NAV database is attached.
  4. Provide the Log on ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required