Excel Buffer to export data and create pivot tables

(0) Share

Report

Posted on by sami khan

Hi all,

I want to export some data to excel and add a pivot table on basis of that data. There are many C/AL examples but i am looking for AL code so i can acheieve that on D365 Business Central.

Please let me know how i can do it on cloud Business Central,

Regards

I have the same question (0)

All responses (1)

Answers (1)

Verified answer

srttel on at

Like (1)

Report

Hi Sami,

we had this functionality for running WinClient when you e.g. export analysis view to Excel. There the data was exported to Excel with a pivot table, unfortunately this does not work currently in WebClient based architecture because the office interop dlls cannot be called in a web client saas solution which are used to render that pivots. This is a subject to change in the future once this export is redesigned.

experience.dynamics.com/.../

This is the view from the Business Central standard application.

Was this reply helpful? Yes No