Ad Hoc Reporting with Microsoft Dynamics NAV 2013: Microsoft Office Excel Add-in, Microsoft PowerPivot for Excel, and Jet Reports Express

I receive a lot of questions when to use what reporting tool provided in Dynamics NAV2013

There was a good item published at the msdn NAV blog

http://blogs.msdn.com/b/nav/archive/2012/08/30/ad-hoc-reporting-with-microsoft-dynamics-nav-2013-microsoft-office-excel-add-in-microsoft-powerpivot-for-excel-and-jet-reports-express.aspx

It also has some nice links to external tools currently available using ODATA:

http://shlemonz.blogspot.ca/2013/01/odata-is-on-of-new-exciting-features.html