Spaces:

mafzaal
/

d365stuff-chat

Sleeping

App Files Files Community

d365stuff-chat / posts /customdataentityopeninexcel.md

mafzaal

Sure! Pl

9ed2c7f 8 months ago

preview code

raw

history blame contribute delete

1.37 kB

metadata

title: x++ Add custom DMF entity to form; Open in Excel
date: 2019-01-18T21:53:06.000Z
lastmod: 2019-01-18T21:53:06.000Z
description: >-
  Use x++ form extension to add custom DMF data entity to a form&#x27;s Open in
  Excel menu.
tags: x++, DMF, Open in Excel, D365, Excel
author: Michael Stashwick
author_url: https://www.d365stuff.co/author/michael/
publisher: D365 Stuff
publisher_url: https://www.d365stuff.co/

18 January 2019 / x++

x++ Add custom DMF entity to form; Open in Excel

We all know that data entities that have the same root datasource (table) as a form will cause the data entity to automagically appear in the form's Open in Excel menu option. What if you need to force add this option via extension? It's a very reasonable request that you'll get asked to do, and is surprisingly hard to research. Until now.

The code has changed a bit throughout D365's evolution. If anything, it's gotten simpler since you no longer have to implement any ExportToExcel* classes.

Need more fields to appear in your Excel sheet? Add them to the AutoReport fieldgroup of the table!