web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Unanswered

Exporting temp tables to excel in AX2012

(0) ShareShare
ReportReport
Posted on by 5

Hello, I am having some troubles trying to export data from a form that uses a temporary table as a datasource, and am wondering if anyone might be able to provide some clarification. The form in question is the Item Requirements form. All tabs/grids will export to excel, except for the Period grid. 'Export to Excel' is greyed out in options only for this grid, and Ctrl+T does nothing. The only difference seems to be that its a temp (in memory) table. I tested creating a few temp tables (both in memory and tempDB) and a form, and found the same issue. Any tabs I added using a regular table as a datasource could export, but not the ones using a temp table of either type. Curiously I did test the 'Create new Entity' wizard under data management, and the 'add fields' page, which uses a temporary table, was exportable. 

Is this a system level restriction, or am I just missing some obvious parameter on the table or form needed to make the export work? The ms docs on temp tables and the export functionality don't list this as a limitation. I know the D365 docs explicitly state that exporting from a temp table is possible, but maybe its not the case in AX2012? 

I have the same question (0)

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 467 Super User 2025 Season 2

#2
Martin Dráb Profile Picture

Martin Dráb 420 Most Valuable Professional

#3
BillurSamdancioglu Profile Picture

BillurSamdancioglu 241 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans