Applying Pivot Table in Excel using Automation Server Objects in NAV

In NAV when building a custom report that deals with totalling the amount by multiple G/L accounts by week then the report becomes tough to read as well as develop in standard SSRS Report. A possible and easy workaround is dumping all the entries in the Excel and performing the pivot table operation on the entries to give a precise results.

Bron : Cloudfronts
Lees meer…