Pivot Tables In Navision 3.7 Non Sql

MatStephensSandA

Hi Guys.

Im an internal dveloper for a Nav 3.7 Native customer(of limited ability).
I have been asked to automate the creation of a pivot table based on data in out Item table.

I have looked at the posts in the forum and the downloads available however the only pivot table creation tool i can find relates to SQL databases only. ](*,)

Is there a tool for Download, advice or a site i can look at that will explain how do do this for 3.7 Native Databases?

I guess as a last resort i could do a basic dump of the data to excel then somehow automate the Wizard in excel but i would prefer to do it all from NAvision..

Thanks in advance
M@