Report Inspector 2.0 – How to export your report dataset as Excel, XML or Windows client style

Today’s post covers some programming that is not of my own making. My colleague Andreas Rascher has built a damn cool functionality that allows you to export the dataset of RDLC reports in different formats. Since we think the functionality is extremely useful, we didn’t want to keep it from you.

Source : Business Central Deep Dive
Read more…

Business Central: Disable data export to Excel for secure data processing

Dynamics 365 Business Central allows you to export data from Business Central to Excel for further processing. In some companies, this function is difficult to perform due to certain data processing and monitoring regulations. Administrators can now manage the control of data export to Excel.

Source : Prisma informatik GmbH
Read more…

How to use the Excel Buffer in Business Central cloud

A week ago, my friend Daniel asked a question on Twitter how to use the Excel Buffer to export data with Business Central online. Many functions on the Excel Buffer are only available for on-prem. When you change the target in app.json to ‘Cloud’ then those functions become unavailable.

Luckily I had a code example available so I decided to put that on GitHub. But I thought it would make sense to write a blog post to explain the code.

Source : Kauffmann @ Dynamics 365 Business Central
Read more…