web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) Show summary of tempor...

Microsoft Dynamics AX (Archived)

Show summary of tempory table for a grid control

(0) Share

Report

Report

Posted on by bernardqin

573

Hi experts,

I want to show summary for a form grid. And I have read following blog as reference:

http://dev.goshoom.net/en/2015/11/summarized-values-in-ax-form/#comment-121778

It does work for regular table, but not a tempory table. Would someone give me some advice?

Thanks.

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (5)

Answers Img

Answers (1)

Martin Dráb 237,980 Most Valuable Professional on at

Like (0)

Report

It'll be almost the same, you just have to pass a reference to the temporary dataset to the aggregation query.

Note that the exact solution depends on whether your table is InMemory or TempDB, therefore if you need more help, please tell us which case it is.

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report

InMemory case

Was this reply helpful? Yes No
Verified answer

Martin Dráb 237,980 Most Valuable Professional on at

Like (0)

Report

Use setCursor() method of the QueryRun object (in updateTotal(), if you're following the blog post) to set the temporary buffer to the query.

Was this reply helpful? Yes No
Suggested answer

bernardqin 573 on at

Like (0)

Report

Solved.

QueryRun.setCursor(TempTable);

Was this reply helpful? Yes No
bernardqin 573 on at

Like (0)

Report

Thanks!

I just figure it out.

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

Martin Dráb 4 Most Valuable Professional

#1

#3

MyDynamicsNAV 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans